Convert date into month name
Solved/Closed
Related:
- Convert number to words in libreoffice calc
- How to convert number to words in word - Guide
- Convert number to words in excel - Guide
- Convert m3u to mp3 - Guide
- Libreoffice download - Download - Office suites
- Mtu calc - 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
Jan 17, 2010 at 07:54 AM
Apr 27, 2010 at 04:05 AM
Apr 27, 2010 at 05:41 AM
May 6, 2010 at 03:32 PM
Jul 19, 2010 at 02:46 AM
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