Expert: Stuart Resnick - 4/27/2010

Question
my question is im dealing with one workbook, and seven worksheets. the worksheets are named the days of the week.
on the sunday worksheet in the B1 box i would like to put the date that starts that week ( 4/25/2010)
then have to carry over to monday and tuesday till the end of the week. so on mondays sheet it will have 4/26/2010 in B1.
im trying to explain this the best i can, does this help?

Answer
You've asked this question in the "Buddhist" category of allexperts.com. But your question isn't about Buddhism.

Still: the job of a Buddhist is to save all beings from suffering. (Actually, this is the job of every human, but sometimes we don't realize it.) Therefore, I'll answer.

Take an Excel workbook on which the first worksheet is named "Sunday"; the second worksheet is named "Monday"; etc. On "Sunday", range B1, enter

4/25/2010

On the "Monday" sheet, cell B1, enter

=Sunday!B1+1

On the "Tuesday" sheet, cell B1, enter

=Sunday!B1+2

etc etc. Now the Monday sheet B1 will display 4/26/2010; the Tuesday sheet B1 will display 4/27/2010; etc etc