You can't format the dates as 2nd Sunday of January 2005 but there are ways
of using formulas to get nth day etc

http://www.cpearson.com/excel/DateTimeWS.htm#NthDoW


Regards,

Peo Sjoblom

"debra adams" wrote:

I have need to show dates as follows: 1/1/05 = 1st Saturday of January...any
ideas out there?