» PivotTable report - Grouping the Date Field by Week Number
To group by week number, add a column to the source data containing the formula WEEKNUM:
1. In the source data, insert new column and enter the WEEKNUM formula into it.
2. In the second argument of the formula, set Return Type to 2 (1 = Sunday, 2 = Monday..
|Screenshot // PivotTable report - Grouping the Date Field by Week Number|