Tip Printed from ExcelTip.com

---

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..