Sorry, I think the reference cell X1 shall be:
=IF(MONTH(TODAY())+8<12;MONTH(TODAY())+8;MONTH(TOD AY())-4)

"Joakim Norrman" wrote:

Cell X1:
=IF(MONTH(TODAY())+8<12;MONTH(TODAY())+8;MONTH(TOD AY())-12)

Cell W1:
=IF(X1=1;X1-1;X1+11)

Then you can drag formula in W1 to column V, U, T, S ... (If wanted)


"C" wrote:

I have a spreadsheet that I need to increment Column X by one on a monthly
basis. When Column x = 12 then it goes back to 0 and column w is is
incremented by one.

Example:

March 2009
Column W Column X
10 11

April 2009 After Calculation
Column W Column X
11 0

May 2009 After Calculation
Column W Column X
11 1

Can someone give advice on how to best accomplish this?

Thanks in advance.
CB