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. 

​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.   Read More

​