Convert date into month name
Solved/Closed
Related:
- Convert date to month
- Convert date to month in excel - Best answers
- Convert date to month excel - Best answers
- Linkedin learning cost per month - Guide
- Amv convert tool - Download - Video converters
- Convert number to words in excel - Guide
- How to convert number into words in ms word in shortcut key - Guide
- How to convert pdf to jpg windows - Guide
2 responses
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
17 Jan 2010 à 07:54
27 Apr 2010 à 04:05
27 Apr 2010 à 05:41
6 May 2010 à 15:32
19 Jul 2010 à 02:46
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