Displaying Day as 1st, 2nd, 3rd, etc. 
Author Message
 Displaying Day as 1st, 2nd, 3rd, etc.

Format>Cells>Number>Custom>dd>OK.
Quote:

> I have a date in column A (mm/dd/yy) and need to display the day of the month as
> 1st, 2nd, 3rd, 4th, etc. in column B.

> Any help would be greatly apprciated.

> Thank you.



Wed, 15 Oct 2003 23:49:24 GMT  
 Displaying Day as 1st, 2nd, 3rd, etc.
Darla,

Try

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

See also http://www.cpearson.com/excel/ordinal.htm .

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC


I have a date in column A (mm/dd/yy) and need to display the day
of the month as
1st, 2nd, 3rd, 4th, etc. in column B.

Any help would be greatly apprciated.

Thank you.



Thu, 16 Oct 2003 00:31:41 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Postions - 1st 2nd 3rd 4th etc

2. Displaying: date: 1st, 2nd, 3rd, 11th, 21st

3. Get 1st, 2nd, and 3rd Letter From a String

4. 1st box<2nd box<3rd box?

5. Return 1st,2nd,3rd,4th from Date

6. 1st month, 2nd month, 3rd month...

7. If 1st cell is empty, I want data from 2nd cell to copy into 3rd cell

8. 1st box<2nd box etc, In forms

9. Calendar control 1st tuesday, 2nd thursday etc.

10. how to show 12th Day of December (1st, 2nd so on)


 
Powered by phpBB® Forum Software © phpBB Group