View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Maistrye Maistrye is offline
external usenet poster
 
Posts: 1
Default change the year in a calendar template to different year


George Wrote:
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


--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=562993