change the year in a calendar template to different year

I have downloaded an employee attendance calendar for Excel, but the year is
2005 and I would like to change it to this year and have the dates change
also.

Originally Posted by George

I have downloaded an employee attendance calendar for Excel, but the year is
2005 and I would like to change it to this year and have the dates change
also.

Depending on how it was set up, you likely will have to go through and do things manually.

You might try to find and replace 2005 with 2006, but I doubt this will do everything you want.

Scott