Help Using Excel Month Function

[andyaf]

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

[mrice]

Try a custom date format of mmmm

[andyaf]

How?

I used
=TEXT(MONTH(B3),"mmmm")

And I only get "January" from each cell

[ChemistB]

it would be

=TEXT(B3, "mmmm")

When you do Month(B3), you get 1 (for January)
Excel sees this as the first day of the start of it's calendar (1/1/1900) so you end up with January
If it's February, you'll get a 2 which is just 1/2/1900 which is still January.

[andyaf]

it would be

=TEXT(B3, "mmmm")

When you do Month(B3), you get 1 (for January)
Excel sees this as the first day of the start of it's calendar (1/1/1900) so you end up with January
If it's February, you'll get a 2 which is just 1/2/1900 which is still January.

Worked Just Fine! Thanks for the help