Grouping data by week via Excel 365

Copper Contributor

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

@Silvaniav 

It shall be greyed if you select anything else except Days

image.png

but

image.png