DateExtensions



Make Excel display a date as 1st, 2nd, 3rd, 4th, etc.


 * 1) Select Insert
 * 2) Select Name
 * 3) Select Define
 * 4) In the Names in Workbook box, enter the word Day
 * 5) In the Refers To: box, enter =DAY(TODAY)
 * 6) Click Add
 * 7) In the Names in Workbook box, enter the word MyToday
 * 8) In the Refers To: box, enter =TEXT(A1,"dddd d")&IF(Day=31,"st",IF(Day=30,"th",CHOOSE(Day,"st","nd","rd","th","th","th","th","th","th","th","th","th","th","th","th","th","th","th",,"th","th","st","nd","rd","th","th","th","th","th")))& TEXT(TODAY," mmmm yyyy")
 * 9) Click Add
 * 10) Click OK
 * 11) Enter =MyToday in any cell.