incrementing the month

[davin1130]

I input the month (ie. January / February / march / ... etc.) into cell A1.

I'm looking for the formula for cell A2 that will increment cell A1 by one month.

I'm NOT using full dates ... just the words January, February, .... etc.
So if i put January in A1 ... February will appear in A2
or if i put June in A1 ... July will appear in A2

 

[Rick Rothstein]

I input the month (ie. January / February / march / ... etc.) into cell A1.

I'm looking for the formula for cell A2 that will increment cell A1 by one month.

I'm NOT using full dates ... just the words January, February, .... etc.
So if i put January in A1 ... February will appear in A2
or if i put June in A1 ... July will appear in A2

Give this formula a try...

=TEXT(31+(A1&1),"mmmm")