How to set the day date in excel to display 1st, 2nd, etc...?

S

Spaced out.

I have a list of "day positional" dates currently displayed as 1, 2, 3, 4
....... etc, and I merely want to show 1st, 2nd, 3rd, 4th ..... I thought
this would be easy to do, but can't find it. Any ideas please on where to
look?
 
G

Gary''s Student

With a value in A1:

=A1&IF(AND(A1>10,A1<20),"th",CHOOSE(MOD(A1,10)+1,"th","st","nd","rd","th","th","th","th","th","th"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to custom format a date 5
date into current and previous quarters 3
How to add day to PWA 2016 date format? 0
Unable to display values in 2nd list box from 1st list box selection 2
Still trying to average 4 worksheets and having formula problems 3
Sorting Data in a Row Question 5
1st smallest, 2nd smallest,3rd smallest 8
Restrict choices in one drop down list by response to another 4

Top