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

1st and 2nd.... positions 21
date into current and previous quarters 3
Format numbers (ie 1st, 2nd, 3rd, 4th, 22nd, etc) 1
Sorting Data in a Row Question 5
Sorting 1st, 2nd, 3rd... 3
1st smallest, 2nd smallest,3rd smallest 6
Trying to create an overdue message based on set dates 5
Formula to get 1st,2nd,3rd,4th,5th Sundays from month end date. 5

Top