Excel How-To

How to Group Dates in a Pivot Table in Excel

Grouping dates allows you to analyze trends over time without manually changing your source data. This feature is essential for creating clean, professional-looking time-based reports.

Do it with AI instead

Step by step

1
Create your Pivot Table
Select your data range, go to the 'Insert' tab, and click 'PivotTable' to place it on a new or existing worksheet.
2
Add the Date field
Drag your date field into the 'Rows' area of the PivotTable Fields pane.
3
Open the Grouping dialog
Right-click any date in the PivotTable and select 'Group' from the context menu.
4
Select grouping intervals
In the 'Grouping' dialog, select the time units you want (e.g., Months, Quarters, Years) and click 'OK'.

Tips

If you don't see the 'Group' option, ensure your date column contains only valid date formats and no blank cells.

FAQ

Why is the Group option greyed out?

This usually happens if your date column contains text values or empty cells that Excel cannot interpret as dates.