date function

C

Carmen

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.
 
N

Niek Otten

Hi Carmen,

In A2:

=A1

Format Custom as "mmm" or "mmmm"

--
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.
 
N

Niek Otten

Or use:

=TEXT(A1,"mmm")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi Carmen,
|
| In A2:
|
| =A1
|
| Format Custom as "mmm" or "mmmm"
|
| --
| 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.
|
| --
| CARMEN HOVENDICK
|
|
 
Top