t cox, use something like this on your other sheets =Sheet1!A1+1...

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"t.cox" wrote in message
...
i would like to make a worksheet with seven pages one for each day of the
week. in a1 on the first page put the date. then have each page
automatically
insert the date
on that day.