Calculate Dynamic Prior 12 Months, Not Current 12 Months

[msquared99]

I have dates from 1/1/2013 thru 9/1/2015 in column A and sales data in column B. Row 1 contains headers.

I can calculate a dynamic current trailing 12 months of sales easy enough (Dates 10/2014 thru 9/2015). My issue is calculating a dynamic prior 12 months of sales (Dates 10/2013 thru 9/2014).

Any suggestions?

Thanks for your time.

 

[Luke M]

You'll probably want to use the EDATE function to calculate the dates you want to use.

 

[msquared99]

Yep, I had to add some helper cells.

For the dates in column A I added Cur. Date =MAX(A:A)
Then TTM Start =EDATE(F7,-12)
Next TTM End =EDATE(F8,-11)

To get the Prior TTM is used: =SUMIFS(B:B,A:A,">="&F9,A:A,"<="&F8)

Thanks Luke!

 

[chirayu]

sample