Calculate monthly values from weekly values, taking into account days in each week

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!

If you attach a sample workbook then we can try out different formulae before submitting a proposed solution to you, which will be tailored to suit your data layout.

Pete

I'm afraid I can't upload attachments from where I am. Here's a table to illustrate my data:

05/07/2015	12/07/2015	19/07/2015	26/07/2015	02/08/2015
523	574	450	310	332

If that that table started in A1, my (unsatisfactory) formula would read:

=(A2/7*5)+B2+C2+D2+(E2/7*5)

The answer I want for July-15 is 1945.

Hope that helps,
Thanks!

Ok, I've now managed to attach an example so hopefully it's easier to see the problem.

At the moment, my formulas in row 5 calculate the figures I want. However, I would like to replace them with a formula that references the months in row 4, and can be copied to each cell without modification.

Hope that makes sense - really appreciate any help, this has me stuck.

Thanks

Can anyone help with this please?