troubleshooting Question

Add (st, nd, rd, th) suffix to a date (or any number) in Excel

Avatar of Steve_Brady
Steve_BradyFlag for United States of America asked on
Microsoft Excel
13 Comments5 Solutions10830 ViewsLast Modified:

In Excel (2010), is there a way to add a suffix (st, nd, rd, th) to a number and specifically to a date?

For example, with today being Monday, July 9, 2012, the following formula returns the value shown:

                    ="July "&DAY(TODAY())

                    July 9

but suppose instead, you want the displayed date to be in the form:

          July 9th

Is there a way to do that?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 5 Answers and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 5 Answers and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros