Add month formula but without day or year

[cizzett]

So I have a spreadsheet that I have a drop down for the month of the data, when I change this month then I want the cell in my next table to increase y 1 month.

In other words if I select June on B2 then I want K2 to change to July.

I have tried a few different formulas but I am failing. Here is what I was trying now
Any guidance is appreciated

=DATE(,MONTH(B2)+1,)

 

[steve the fish]

Depends on your local settings but this may work:

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

 

[cizzett]

That works great, thanks