How you do it is going to depend on what form the "old Dates" are in ...
Are they text?
Are they Date Values?
Are they formula results?

Take a look at a few dates and post back with what you find.
Rgds,
ScottO

"Denise" wrote in message
...
| I downloaded the 2004 - 2005 student attendance template but how do I
change
| the dates to make it a 2005 - 2006 attendance sheet? Please e-mail me this
| infomation at