One Simple Method for Creating Dates in Excel That look like this “24th September 2060” (1st, 2nd, 3rd, 4th etc.)

Loading

Having a date that looks complicated makes our daily task stressful and confusing.

Therefore, our team at Supedium.com found out an easy way to make your excel date look more presentable and professional.

By following the formula provided below you can instantly get the result you want!

The full formula is as follows:

=DAY(A2) &
IF(OR(DAY(A2)=1, DAY(A2)=21, DAY(A2)=31), "st",
IF(OR(DAY(A2)=2, DAY(A2)=22), "nd",
IF(OR(DAY(A2)=3, DAY(A2)=23), "rd", "th")))
& " " & TEXT(A2, "mmmm") & " " & YEAR(A2)

You can replace (A2) with the cell that contain the date you want to convert

For Example:

First you paste in the code above in the cell as shown on the left side

Sample 2 just replace the A2 to A3

Sample 3 just replace the A3 to A4

After that it will automatically convert the date to the format of 24th September 2060

That’s all easy right!

Enjoy!

Share This
2Shares

1
See also  Long and Short Writing for Online
  • Be the first to comment

Back to top of page

Register / Login

Message from SUPEDIUM®


Welcome to SUPEDIUM®, to ensure you have seamless experience when browsing our website, we encourage all users to register or login. It only takes less than 2 minutes to register an account :)

Register / Login with Email

Register / Login with Google

This will close in 30 seconds

Sign in

rotate_right

Send Message

image

My favorites

image