Excel pivot table grouping data range into weeks

[marcelbijlsma]

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.

[#2 · Accepted solution]

@marcelbijlsma 

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

[#3]

@Detlef Lewin thanks! that suggestion will do.