Convert date into month name

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

2 replies

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
216
Thanks, that came very handy
0
good that's working
0
edme1122@yahoo.com
Apr 27, 2010 at 05:41 AM
hiiii my password pleas
0
Fantastic
0
the formula is correct
Suppose you have 1/1/09 in cell A1,
Then use cell B1 to input this formula: =TEXT(A1,"mmm") .

but if the date format would be dd/mm/yyyy than how can I convert it
0
Thanks for your nice tips
20
Worked a treat - much easier than another solution a work colleague gave me.
0
This worked perfectly, thanks for the help!
0
Thanks for help
0
Solution works great and easier too. hatsoff.
0
Thank you
0