Date to Month

[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?

 

[Norman Harker]

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.

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?

 

[Gord Dibben]

Tim

With date in B1, in M1 enter =MONTH(B1)

Gord Dibben Excel MVP