PivotTable Month Groups Article

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.




Posted in , ,

Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

Excel is not what it used to be.

You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.

Want to learn Excel?

Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.


  1. Amar Nath Verma on May 7, 2015 at 10:08 am

    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.

    • jefflenning on May 14, 2015 at 12:25 pm


      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 Comment