Help Using Excel Month Function

[akers77]

Hi,


I need some help transferring a portion of a date from one excel to another. On the file attached, the 1st column lists the date, and the second column needs to show the date in text format


3-Jan-14 —> “January”


Any ideas how this can be done?


Many thanks!


-Andrew

[tcambridge]

Try this:

=Text(B3,"mmmmmmm")

[westconn1]

try
=TEXT(B6,"mmmm")

[akers77]

try
=TEXT(B6,"mmmm")

Worked just fine! Many thanks!