Rolling Forecast

[Ldyflyr]

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.

[Flintstone]

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