date function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carmen - 04 Jan 2007 19:34 GMT

I have a cell A1 with date 5/2/07. If in cell A2 I do month(A1), I get 5. Is there a way to return May instead? either through a command or formatting? I can reference cell A2 with the 5 with a if(cell = 5, "May", ) in cell A3, but the date in cell A1 varies from Jan to Dec and the 12 embedded if's in cell A3 are too long (that is the error I get when trying to do so), plus it is very inefficient.

Thanks.

Signature

CARMEN HOVENDICK

Reply to this Message

Niek Otten - 04 Jan 2007 20:08 GMT

Hi Carmen,

In A2:

=A1

Format Custom as "mmm" or "mmmm"

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

I have a cell A1 with date 5/2/07. If in cell A2 I do month(A1), I get 5. Is there a way to return May instead? either through a
command or formatting? I can reference cell A2 with the 5 with a if(cell = 5, "May", ) in cell A3, but the date in cell A1 varies
from Jan to Dec and the 12 embedded if's in cell A3 are too long (that is the error I get when trying to do so), plus it is very
inefficient.

Thanks.

Signature

CARMEN HOVENDICK

Reply to this Message

Niek Otten - 04 Jan 2007 20:13 GMT

Or use:

=TEXT(A1,"mmm")

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi Carmen,
|
[quoted text clipped - 10 lines]
|
| Thanks.

Reply to this Message

Carmen - 04 Jan 2007 20:58 GMT

Niek, CLR, Gord

Thanks, worked like a charm.

Signature

CARMEN HOVENDICK

> Or use:
>
[quoted text clipped - 20 lines]
> |
> | Thanks.

Reply to this Message

Gord Dibben - 04 Jan 2007 20:20 GMT

Carmen

Custom Format A2 to mmmm

Gord Dibben MS Excel MVP

>I have a cell A1 with date 5/2/07. If in cell A2 I do month(A1), I get 5. Is there a way to return May instead? either through a command or formatting? I can reference cell A2 with the 5 with a if(cell = 5, "May", ) in cell A3, but the date in cell A1 varies from Jan to Dec and the 12 embedded if's in cell A3 are too long (that is the error I get when trying to do so), plus it is very inefficient.
>
>Thanks.

Reply to this Message

Rate this thread: