EOMONTH query for distributing a project volume over a period of time, with the breakdown in weeks (date as end of each week)|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi,

I have a query regarding breaking down a project volume over weeks, with the date as end of each week. 

Please find attached my current file. 

My current formula shows the first week that the volume hits as the total volume, and then depreciates it each week forward.