View Single Post
  #1   Report Post  
Daniel
 
Posts: n/a
Default 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