Grouping data by week via Excel 365

Highlighted
Occasional Visitor

Hi,

 

Has anyone else ran into a problem when grouping data from a pivot table weekly. I am not able to enter the number of days under the grouping function (greyed out). Does anyone has any suggestions?

 

Much appreciated,

Silvania

 

1 Reply
Highlighted

@Silvaniav 

It shall be greyed if you select anything else except Days

image.png

but

image.png