• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Making dates show with text

Busymanjohn

Busymanjohn

Member
Hi, I am looking for a little help with dates .... I am creating a new spreadsheet and I want a date to appear in three separate cells ( which will be then be shown in rectangle shapes ), I can easily get the day of the week in one cell, the month in another and the date ( e.g. 17 ) in a third cell ,,, but I would like the 17 to appear as 17th .... or if the current date is the 21st, show as 21st ... is this possible ?
 
=A1&IF(AND(MOD(A1,100)>=10,MOD(A1,100)<=14),"th", CHOOSE(MOD(A1,10)+1,"th","st","nd","rd","th","th","th","th","th","th"))


Thanx http://www.dailydoseofexcel.com/archives/2004/07/19/ordinal-days/
 
You must log in or register to reply here.
Back
Top