How to change date format in Excel?
Closed
Manikanta
-
5 Jul 2018 à 08:23
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Jul 2018 à 11:24
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Jul 2018 à 11:24
Related:
- Change excel date format
- Change date format excel - Best answers
- How to change the date format in excel - Best answers
- How to change date format in excel - Guide
- How to clear formatting in excel - Guide
- How to change language in idm - Guide
- How to change date format in excel to dd-mm-yyyy - Guide
- How to change computer name - Guide
2 responses
Zohaib R
Posts
2368
Registration date
Sunday 23 September 2012
Status
Member
Last seen
13 December 2018
69
5 Jul 2018 à 15:29
5 Jul 2018 à 15:29
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 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
10 Jul 2018 à 11:24
10 Jul 2018 à 11:24
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
