I have 10 different excel spreadsheets, each with 52 worksheets with a date.
It is our new year and the dates were manually entered. my question....

is there a formula i can enter so it picks up the worksheet before it and
adds 7 days to the new worksheets so i do not have to manually change all of
these dates on all 52 worksheets.

right now i have been clicking on each worksheet and manually chnaging the
dates, but getting to be a pain.

Thank you!