Group data by weeks not months

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of weekly data 11
Month, DATE, Week 7
Name The Week Of The Month 7
Day/Date/Week 3
COUNTIF, MONTH, YEAR 4
Problem with expression (sum) 1
Spreading date range across days in weeks (advanced) 7
Grouping by month in a Pivot Table 1

Back
Top