ExcelBanter - Weekly Pivot Tables

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Weekly Pivot Tables (https://www.excelbanter.com/excel-discussion-misc-queries/198567-weekly-pivot-tables.html)

Michael G.

Weekly Pivot Tables

How can I set up a pivot table that will group dates into 5-day weeks? Thanks
--
Mike Gudyka
St.Charles, IL

Herbert Seidenberg

Weekly Pivot Tables

Add a column to the source data
that flags the workdays.
Use this column as the page field.
Group dates by 7 days.
Sample file at:
http://www.savefile.com/files/1725207

All times are GMT +1. The time now is 02:51 PM.