Group data by weeks not months
Hi,
I have some data that I summarised by pivoting it and grouping by month using the Month() function in excel. However I need to break it down into weeks not months, either week1 week2 week3..... etc or by month with weeks underneath. I have no idea of how to do this can anybody help please?!! Cheers Daniel |
Just add another column to your source data that looks at the date and
returns a week number, then pull that into your report. If your dates cross years, then either add a Year identifier to your weeknumber based on the date it is pulling from, or add another column that gives you the Year as well, then pull both and combine as necessary to produce what you want. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Daniel" wrote in message ... Hi, I have some data that I summarised by pivoting it and grouping by month using the Month() function in excel. However I need to break it down into weeks not months, either week1 week2 week3..... etc or by month with weeks underneath. I have no idea of how to do this can anybody help please?!! Cheers Daniel |
All times are GMT +1. The time now is 01:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com