Convert date into month name [Solved/Closed]

danny - Jul 31, 2009 at 06:24 AM - 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 

20 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

Something to say? Add comment

CCM has helped 1667 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