date function

Giganews Newsgroups
Subject: date function
Posted by:  Carmen (hovend…@yahoo.com)
Date: Thu, 4 Jan 2007

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 =3D 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.

--=20
CARMEN HOVENDICK

Replies