PivotTable Month Groups Article

PivotTable article by Jeff Lenning

PT Figure 3 by Jeff Lenning
Did you know that PivotTables can automatically group date fields by month? And by quarter and year? This date group capability makes it easy to summarize data in monthly columns without writing a single formula. Check out my recent California CPA Magazine article for the details.




Get a quick email notice when a new Excel article is available

  • This field is for validation purposes and should be left unchanged.

This article was written by Jeff Lenning


  1. Amar Nath Verma

    Hi Sir, i am your fan of your site. I am learn may think of your site, one think or tell me if i group date field in year and quarter in india accounting year start Apr, this is Qtr 1 but excel pivot table so Qtr 2 how to solve this problem Qtr2 to change qtr1.

    1. jefflenning Post author


      There are a couple options that come to mind. One is to manually rename the labels by typing Q2 into the default Qtr1 cell. This label change is retained on refresh. Another way to do this is to define your own quarter groups, rather than using the built-in calendar year groups, by using a mapping table. This approach is discussed here:

      Hope these ideas help!


Leave a Reply

Your email address will not be published. Required fields are marked *

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.