Friday, March 13, 2009

clever Excel format

As this example shows you can apply nice looking formats in Excel, so that a simple date appears as "Friday the 13th" using custom format. You could also do this using the text() function with if processing to allow for the "st", "nd" and "rd".

No comments: