I want to calculate monthly values from weekly ones, by taking into account the number of days in the weeks that overlap each month.
So far I've been using a formula like this for July-15 for example:
=('Weekly'!T53/7*5)+'Weekly'!U53+Weekly'!V53+'Weekly'!W53+('Weekly'!X53/7*5)
It's taking 5/7 of the values for first and last weeks, because 5 of their 7 days were in July.
However, I want a formula that will do this automatically, and doesn't require me to manually change the number of weeks/days depending on the particular month.
Any help would be much appreciated - thanks!
Bookmarks