Check Month Name in Cell, based on that put next month name in another cell

[hananak]

Hi Everyone,

Need a quick solution. I have a drop down list in in cell A1 with months name as text. If someone select any month from the drop down list. I want in cell B5 next month's name.

Suppose if someone chooses in cell A1 "January" from the drop down list then in cell B5 February should appear as a text and not as a date.

Your help would be really appreciated.

 

[Eric W]

Try:

=TEXT(EDATE(1&A1,1),"mmmm")

 

[hananak]

Try:

=TEXT(EDATE(1&A1,1),"mmmm")

Hi Eric,

Thank you very much for quick response. It works flawlessly.