How to create dynamic rolling month and year?
I am trying to create a table to calculate score from another sheet on a 12 months rolling basis, this data is to be published on the dashboard.
It's easy to have the 12th month data which is current month.
However this formula doesn't work across the board as shown above, month-9 would be 0.
How can I have a formula to capture the rolling month and year so that I can then sum or average the score from the score sheet base on these rolling month and year?
Appreciate assistance. Thanks.
Help Article Resources
Check out the Formula Handbook template!