How to change date format in Excel?
Closed
Manikanta
-
Updated on Jul 5, 2018 at 11:55 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 10, 2018 at 11:24 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 10, 2018 at 11:24 AM
Related:
- How to change date format in Excel?
- Excel date format dd.mm.yyyy - Guide
- How to change time format in whatsapp - Guide
- How to change author in excel - Guide
- How to change language in kmplayer - Guide
- Marksheet format in excel - Guide
2 responses
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Jul 5, 2018 at 03:29 PM
Jul 5, 2018 at 03:29 PM
Hi Manikanta,
Hope you are doing good. If A1 Contains "25-06-2018" then this formula will change the date to your desired format:
Notice Th in the forrmula, you can replace it with th to suite your need.
Hope you are doing good. If A1 Contains "25-06-2018" then this formula will change the date to your desired format:
=TEXT(DATE(RIGHT(A1,4),RIGHT(LEFT(A1,5),2),LEFT(A1,2)),"dd")&"Th" & " " & TEXT(DATE(RIGHT(A1,4),RIGHT(LEFT(A1,5),2),LEFT(A1,2)),"MMMM YYYY")
Notice Th in the forrmula, you can replace it with th to suite your need.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Updated on Jul 10, 2018 at 11:25 AM
Updated on Jul 10, 2018 at 11:25 AM
Hello,
May I suggest the following:
=DAY(A1) & "Th " & PROPER(TEXT(A1,"mmmm yyy"))
Best regards,
Trowa
May I suggest the following:
=DAY(A1) & "Th " & PROPER(TEXT(A1,"mmmm yyy"))
Best regards,
Trowa
