Convert date into month name [Solved/Closed]

- - Latest reply:  Manoj - Jan 14, 2013 at 05:51 AM
Hello,

suppose date has mention 1/1/09 and no month name then how to get the month name
See more 

2 replies

Best answer
215
Thank you
Danny, did you even try Venkat's solution.

I tried it and it works like a charm, guess you would like to read it again:

Suppose you have 1/1/09 in cell A1,
Then use cell B1 to input this formula: =TEXT(A1,"mmm") .
If you want the full monthname instead of 3 letters add another m,
like this =TEXT(A1,"mmmm") .

Hope it's clear now.

Best regards,
Trowa

Thank you, Trowa 215

A few words of thanks would be greatly appreciated. Add comment

CCM has helped 2562 users this month

it is not working
i m trying to convert my date into month text it shows whole formula in the cell where the formula typed,

my date format is: dd.mm.yyyy

can you plz explain will this formula work on this type of date format?
Perfect! Thanks.
its simple, u've to combine d-elecminate function in excel... i.e first select colmun containg the date as dd.mm.yyy, the press ctrl+d+e, this will open a window use d-elimiate and in other check box use "/". This will separate date into three columns, convert first colum into number, them use & to replace date with month column.
Once all done convert again number into date column.. :)
20
Thank you
Thanks for your nice tips
Thanks for help
Solution works great and easier too. hatsoff.
worked great for me too. You can also use "dddd" or "yyyy" if you want to display the day or year respectively.
Thanx great tip