20 votes4 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
The best way to accomplish this is to add a column to your data that specifies the week. By using a custom formula, you can organize the weeks any way you want, with any starting day of the week, and also name them any way you want, whether “Week of July 10” or “Week 34” or something else. Then you can use that column in a PivotTable to see data grouped by week.
An error occurred while saving the commentAnonymous commented
totally agree - currently using a silly work around with formula