How to change date format in Excel? [Closed]

Report
-
Posts
2696
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 28, 2021
-
Hello,

Sir I want change date format in 25-06-2018 to 25th June 2018


How can change 25 in Th letter in upper case

Please tell me any one

2 replies

Posts
2368
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
19
Hi Manikanta,

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.
Posts
2696
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 28, 2021
457
Hello,

May I suggest the following:
=DAY(A1) & "Th " & PROPER(TEXT(A1,"mmmm yyy"))

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!