How can I set up a pivot table that will group dates into 5-day weeks? Thanks
M Michael G. Aug 12, 2008 #1 How can I set up a pivot table that will group dates into 5-day weeks? Thanks
H Herbert Seidenberg Aug 12, 2008 #2 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
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
