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