Peo/Trevor:

Excellent service as usual. Thanks very much.

MARTY

"Trevor Shuttleworth" wrote:

Marty

if the date is in cell A2, just put =A2 in another cell and give it a custom
format of "mmm" for Jan, Feb, Mar, etc and "mmmm" for January, February and
so on

Regards

Trevor


"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