Rolling Forecast
 

I want to create a spreadsheet with columns using a rolling forecast. Is
there a function or a method to have the columns move against a calendar? For
example, I want Period 1, Period 12, Period 11 this month, then next month I
want the columns to be Period 2, Period 1, Period 12 etc.

Rolling Forecast
 

Hello Ldyflyr

Today’s date in cell A1, then paste each formula in cells A2, B2, and
C2 respectively.

="Period "&CHOOSE(MONTH(A1),10,11,12,1,2,3,4,5,6,7,8,9)
="Period "&CHOOSE(MONTH(A1),9,10,11,12,1,2,3,4,5,6,7,8)
="Period "&CHOOSE(MONTH(A1),8,9,10,11,12,1,2,3,4,5,6,7)

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=533542