Pinterest Pixel

Group Dates with a Pivot Table

Group Dates with a Pivot Table Grouping Dates is very easy with a Pivot Table.  All you... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Group Dates with a Pivot Table | MyExcelOnline Group Dates with a Pivot Table | MyExcelOnline

Group Dates with a Pivot Table

Grouping Dates is very easy with a Pivot Table.  All you have to do is Right Click on your Date values (which are either in the Row or Column Labels of your Pivot Table), then choose the Group option.  From the dialogue box you can choose to Group by Days, Months, Quarters or Years.

Download excel workbookGroup-Dates2.xlsx

 

STEP 1: Right click on your Date values and choose Group.

Group Dates with a Pivot Table

 

STEP 2: Select the combination of grouping you prefer. Click OK.

Group Dates with a Pivot Table

Your pivot table is now grouped by dates!

Group Dates with a Pivot Table

 

If you like this Excel tip, please share it
Group Dates with a Pivot Table | MyExcelOnline Group Dates with a Pivot Table | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...