Adding cumulative week of year from a file with only Month and Year
I have searched the many Q&A's relating to this question and unfortunately I can't get any of the solutions to work for my specific problem, please help!
Attached is the annual budget file, it contains a category for the particular budget line, the month and year as the date and the budget for that budget line and month (I've dummied the budget data) on "sheet 1"
On "sheet 2" I've added what I'd like the transformed data to look like (I've only dummied the data for Jan but I'd like it to do the same thing for the whole year).
Essentially, I need to split out the monthly budget data into weeks, week 1-week 52 for the year so we can track spend against budget on a weekly basis.
The RC monthly budget line of £20 becomes £4 if there are 5 weeks in the month.
I don't want the weekly recount to restart at the beginning of each month, it should run right through to 52
Any help would be much appreciated at this point 🙂