MONTH()

[Gordana Godzo]

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: (e-mail address removed)

 

[Marcelo]

Hi Gordana

try on B1:

=Month(a1)+1

regards from Brazil
Marcelo

"Gordana Godzo" escreveu:

 

[aidan.heritage]

EDATE would do it, or if the date is ALWAYS the first of the month,
then

=A1+31


will force the date to move onto SOMEWHERE in the next month, and your
formatting will display the desired result.

 

[Ron Coderre]

Gordana

If the value in A1 is a date (vs text that looks like a date), try one of
these:

This uses the Analysis ToolPak add-in:
B1: =EOMONTH(A1,0)+1

OR

This one uses regular Excel functions:
B1: =DATE(YEAR(A1),MONTH(A1)+1,1)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

 

[David Biddulph]

"Gordana Godzo" escreveu:

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.

 

[Marcelo]

just format as mmmm

So easier

Marcelo

"David Biddulph" escreveu:

 

[David Biddulph]

"David Biddulph" escreveu:

just format as mmmm

So easier

Marcelo

I'll ask again, Marcelo, *did* you try your suggestion? [... or have you
looked at help on the MONTH function?]

With a date of May-06 in A1, MONTH(A1) returns the number 5, so your formula
=MONTH(A1)+1 gives the answer 6 [a number, not a date]. If you format the
cell as mmmm it displays as January [as the number 6 represents 6th January
1900 if you treat it as a date].

The OP wants the answer to be Jun-06.