Hi all,
I've got a bit tricky problem in my hands...
I have a forecast that I get in a monthly format. I would like to split this forecast evenly into weeks automatically.
The problem is that I can't really figure out how to handle the months that have 5 weeks. Otherwise I would just create a macro that adds four cells in front of each month and divide the monthly value into weeks.
The weekly forecast should fall on Tuesday. Any ideas on this one?
Thanks already in advance!
Forecast_ExcelForum.xlsx
Bookmarks