Help, I'm looking for a formula to calculate a rolling backwards forecast with actuals, based on a date field to calculate a rolling 12 month total. I'd like to automate it based on the current date so should take last twelve months from today.
For example:
Month1 Month 2 Month 3...... to month 12 and then next month add in month 13
100 120 100
So for the first month the total will be the sum of month 1 to 12
next month the value will be month 2 to 13
next month value will be month 3 to 14
I need it to be a formula in a cell and not VBA.
I can do it via a sumif on the basis that someone manually enters it a condition and takes the condition out the next period, but do not want to rely on individuals, so any way to automate would greatly be appreciated.
thanks in advance
For example:
Month1 Month 2 Month 3...... to month 12 and then next month add in month 13
100 120 100
So for the first month the total will be the sum of month 1 to 12
next month the value will be month 2 to 13
next month value will be month 3 to 14
I need it to be a formula in a cell and not VBA.
I can do it via a sumif on the basis that someone manually enters it a condition and takes the condition out the next period, but do not want to rely on individuals, so any way to automate would greatly be appreciated.
thanks in advance