Month Serial number to Month name

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

for instance i get the month's serial number of
11/03/2004 or 11 March 2004 (B3)
==MONTH(B3)

is there anyway for me to convert the return value (3) to "March" without
vba

Thanks in advance
 
Dave

You can just format the cell as mmmm

This will retain the date within it. If you just want March, as text, use:
=TEXT(B3,"mmmm")

Andy.
 
thanks very much for the prompt reply

Andy B said:
Dave

You can just format the cell as mmmm

This will retain the date within it. If you just want March, as text, use:
=TEXT(B3,"mmmm")

Andy.
Click to expand...
 
Hi Dave!

Just to clarify.

If date is in B3, =B3 formatted mmmm returns full month name. If you
format =MONTH(B3) as mmmm you'll get January because the date serial
numbers 1 to 12 are all dates in January 1900 (the base year).

If you just have the month number in A1 you can use =A1*29 and that
can be formatted as mmm or mmmm. But that's not necessary here as you
have the date.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top