Convert date into month name
Solved/Closed
danny

Manoj 
Manoj 
Related:
 Excel convert month name to number
 Excel convert number to month  Best answers
 How to get month name from date in excel  Best answers
 How to convert month date year in excel  HowTo  Excel
 Excel convert number to words  HowTo  Excel
 Excel convert yyyymmdd to date ✓  Forum  Excel
 Excel convert date to general  HowTo  Excel
 Excel  Convert hours in decimal  HowTo  Excel
2 replies
Trowa
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
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
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