It might just be mmm for a short name.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Peo Sjoblom" wrote in message
...
=TEXT(A1,"mmmm")

or just link

=A1 and use a custom format of mmmm

--

Regards,

Peo Sjoblom


"Marty" wrote in message
...
Hi all:

I'd like to return the month (Jan, Feb, Mar, etc.) from cells containing
dates.

Some variation of (formulas in column B):

=IF(MONTH(A1)=1,"Jan",IF(MONTH(A1)=2,"Feb",...

would be nice, but you can see the problem this gives, i.e. Excel allows
a
maximum of seven nested Ifs.

I want to do this with a formula instead of VBA. Anyone have a
suggested
woraround for this?

Thanks in advance.

MARTY