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.

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