Hi Gordana

try on B1:

=Month(a1)+1

regards from Brazil
Marcelo

"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?

Thanks
--
Gordana Godzo
Head of Controlling & Budgeting
TITAN Group - Cementarnica "USJE" AD Skopje
Prvomajska bb, 1000 Skopje
tel: +389 2 2786 138
fax: +389 2 2782 535
e-mail: