Date abbreviations / extensions
Is there a way to have dates show with extensions like, "st", "nd", "rd", "th"
when using the NOW() formula? In other words, when the date changes from the 1st to the 2nd will Excel display the extensions? Or, is there a way automatically to spell out the dates, (First, Third, Sixteenth, etc.) using the NOW() or some other formula?
Thanks,
K
|