Formula to fill in consecutive months based on start month

[lichldo]

Is there a formula (not autofill) this scenario -

I manually enter a month (lets say, March) into cell F2. Now I want to add a formula into cell M2 that will recognize F2 says March, and put the next month, April, in cell M2 where the formula is. I do not want the full month/day/year - only the month

 

[kweaver]

How about:

=TEXT(31+DATEVALUE(F2&" 1, 2022"),"mmmm")

 

[bebo021999]

Example.xlsx
	F						L	M
1
2	Mar							April
3	March							April
4	Apr							May
5	Dec							January
6	December							January
7	Jan							February
8	January							February
9
Sheet4

Cell Formulas
Range	Formula
M2:M8	M2	=TEXT(DATEVALUE(28&F2)+4,"mmmm")