Forum Discussion

marcelbijlsma's avatar
marcelbijlsma
Copper Contributor
Apr 11, 2024

Excel pivot table grouping data range into weeks

In a pivot table with a date range, how can I group that date range into weeks. Grouping seems to be restricted to hours, Days, months, years.
  • Detlef_Lewin's avatar
    Apr 11, 2024

    marcelbijlsma 

    You can group by 7 days or insert a column "Week" in the source data.

     

Resources