Break down monthly volume into accurate weekly numbers

[koskesh]

Hello,

I have monthly volumes and I want to split them into accurate weekly volumes.

Lets say I have 500 in August and 600 in September

Week 35 is 3 Days of August and 4 Days of September.
500/31 * 4 + 600/30 * 2 = 104,5 for Week 35.

What formula can I use if I have only the Weeknumber and the Monthly volumes.

Thanks

 

[NARAYANK991]

Hi ,

See the attached file.

The week number should be the correct week number for the last date of the month.

Narayan