I want a the to display the Month name only. Nothing else.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DAiuto - 26 Sep 2007 23:10 GMT

I have a formula the following formula =EDATE(A3,1) that gives me a result of
"May-07" because the cell is formatted as:
Catagory = Date
Type = Mar-01
But I don't want the year to display, just the month. Any idea how I can do
that?

Thank you,
DAIUTO

Reply to this Message

Gord Dibben - 26 Sep 2007 23:39 GMT

Custom Format as mmm or mmmm for March

Gord Dibben MS Excel MVP

>I have a formula the following formula =EDATE(A3,1) that gives me a result of
>"May-07" because the cell is formatted as:
[quoted text clipped - 5 lines]
>Thank you,
>DAIUTO

Reply to this Message

DAiuto - 26 Sep 2007 23:56 GMT

Is that all? I'm going in the other room to laugh at myself... sorry for
bothering all of you. : )

> Custom Format as mmm or mmmm for March
>
[quoted text clipped - 9 lines]
> >Thank you,
> >DAIUTO

Reply to this Message

Gord Dibben - 27 Sep 2007 00:19 GMT

Not a bother and you should see the number of rooms I've had to go into<g>

Gord

>Is that all? I'm going in the other room to laugh at myself... sorry for
>bothering all of you. : )
[quoted text clipped - 12 lines]
>> >Thank you,
>> >DAIUTO

Reply to this Message

Rate this thread: