View Single Post
 
Old 08-26-2016, 07:53 AM
chollyred chollyred is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Aug 2016
Posts: 2
chollyred is on a distinguished road
Default Rolling up monthly results based on weeknum?

I have a large amount of data that has to be reported weekly and monthly. I was able to use ISOWEEK to create my weekly results along with Week Beginning and Week Ending dates. However, I have not been able to roll those weekly results up to Monthly results. I'm trying to avoid having to create individual formulas for each month like Jan = 1-5, Feb =6 - 10, Mar = 11-15 etc.

Any way to do this? I can't use the MONTH of the date since many of those cross into different weeknums.

Thanks!

Also posted at http://www.mrexcel.com/forum/excel-q...d-weeknum.html

(note: newbie hand slapped, but no solution offered)
Reply With Quote