Forum Discussion
Pivot Table Date Grouping
I am trying to group dates in my PivotTable. All or most of the videos I've watched have said to right click & the option for grouping/ungrouping should be there. It's not. I believe the dates are correctly formatted but I could be wrong (I did double check by going to the home tab & in the number section date was selected but I chose general & then long date & switch the country to UK). Still, I'm not getting the option. I also went to the data tab & clicked on group. Still, no option to group.
For reference I am using the web-based version of Excel via Microsoft365.
Any help would be appreciated.
2 Replies
The Group and Ungroup options are only available in the desktop version of Excel, not in the online (browser) version.
You can add your vote to Date grouping for PivotTables in Excel for the web. Microsoft is already considering this - the more votes it gets, the likelier it is that it will be implemented.
HansVogelaar Thank you for responding swiftly. Hopefully it's added soon.
