just format as mmmm

So easier

Marcelo

"David Biddulph" escreveu:

"Marcelo" wrote in message
...

"Gordana Godzo" escreveu:

I need a very simple formula, but I just can not figure it out:
In cell A1 for example I have the month in format mmm-yy (May-06)
Cell B1 should return the next month (Jun-06)
How do I do that?

Hi Gordana

try on B1:

=Month(a1)+1

regards from Brazil
Marcelo

Did you try your suggestion, Marcelo?
That gives the answer 6, not what the OP asked for.
--
David Biddulph