Simple date problem (I think)

Hello,

So I'm building a workbook, and I have one cell called Jan (January), cell A1, and I want the cell next to it, cell B2, to equal Feb based off the fact that cell A1 is Jan. A1 is linked to another workbook, so if cell A1 changes to Mar then I want cell B2 to automatically change to Apr. I want B2 to be able to change to the month following A1, whichever month it is. And I also need it to work using only the first 3 letters of the month. How do I do this?

Hello and welcome to the forum.

B2 is not next to A1.

That being said, assuming that the 3 letter month is text and not an actual date, try this:
=TEXT(EDATE((A1&" 1")+0,1),"mmm")

Originally Posted by Sambo kid

if January in A1 is an actual date then this in B2 will change it by one month =EDATE(A1,1)

I had already tried this and it didn't work. Probably because A1 isn't an actual date. It's just the name of the month, and on top of that only the first 3 letters of the month.

Originally Posted by 63falcondude

Hello and welcome to the forum.

B2 is not next to A1.

That being said, assuming that the 3 letter month is text and not an actual date, try this:
=TEXT(EDATE((A1&" 1")+0,1),"mmm")

This worked perfectly. Thank you so much. And my mistake regarding B2, I meant B1.

You're welcome. Happy to help.

Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.