copy sheet with updated dates
 

I have a sheet with a schedule of random events (duties) for employees. At
the top of the sheet I have "For the week of March 6, 2006." I would like
to copy the sheet and have the date automatically move +7 days.

My goal is to print out 6 months or a years worth and not have to go through
and add the date to each sheet.

Any ideas?

Thanks