Rolling Forecast

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top