Convert date into month name

Solved/Closed
-
 Manoj -
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
Thanks, that came very handy
good that's working

hiiii my password pleas
Fantastic
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
Thanks for your nice tips
Worked a treat - much easier than another solution a work colleague gave me.
This worked perfectly, thanks for the help!
Thanks for help
Solution works great and easier too. hatsoff.