I would like to have an automated Excel formula that calculates the last 12 month and the previous time period 12 months. For example since we are now in July 2014, I want the June 2014-July 2013 period and in another cell the June 2013-July 2012 total. On the attached spreadsheet I have two products with their values and the columns of the months. Each product will need the current 12 months past and the last year 12 months.
Thanks.
Hi there,
check attached file:
Rolling 12 Example.xlsx
Last 12months (2013-2014) calculated in col A:
Formula:
Please Login or Register to view this content.
and the other scenario for 2012-2013 is in col B:
Formula:Please Login or Register to view this content.
Booth are array formulas and they needs to be confirmed with Ctrl+Shift+Enter instead of Enter.
Also I made small modification in Your formula in cell B2:
Before:
Formula:Please Login or Register to view this content.
Now:
Formula:Please Login or Register to view this content.
Hope it helps!
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
Excellent. That is perfect.
You are welcome! ;-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks