Hi All
I am trying to get a formula that does a running 12 month total for a series of date periods (up to 6 years so could include periods during a leap year).
Period Ending Value per period Running 12 month total
01/01/2020 1 1
08/01/2020 3 4
15/01/2020 5 9
16/01/2020 22 31
29/01/2020 1 32
As we reach a period ending date of 02/01/2021 then the period ending 01/01/2020 would drop out of the running 12 month total
The running 12 month total needs to be calculated for each period ending date.
Also exactly the same as above but also for a 52 week period
Many thanks in advance
Bookmarks