Date to Month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a dd/mmm/yyyy format in column B and i have to reference that column to column M but convert it so only the Month is displayed could anyone tell me what function i need to use?
 
Hi Tim!

If you only want to *display* the month:

=B1
Format mmmm

If you want the month as text:

=TEXT(B1,"mmmm")

--
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.
Tim said:
i have a dd/mmm/yyyy format in column B and i have to reference that
Click to expand...
column to column M but convert it so only the Month is displayed could
anyone tell me what function i need to use?
 
Back
Top