A question that is often asked when I cover Pivot Tables in Excel courses is “Can I group the data by months?”
The answer is “yes you can”. In fact you can group by days, months, quarters and years, as well as hours and minutes!
In August 2012 I delivered a webinar about Pivot Tables. The recording of the 1-hour webinar is available for purchase from here. Below is a short (less than 3 minutes) clip, extracted from the video, in which I demonstrate how to group data in a Pivot Table by month and by day.
I used Excel 2011 for Mac, however, the information and demonstration is equally valid for Excel for Windows
The supporting documentation can be downloaded here