Thanks for your response. I've just noticed a response to an earlier
post that will give me what I need as well:
=OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),-1,0)+7. With this, I'll
have VBA type it in the cell as I need it. It will automatically pick
up the date from the cell above and add 7 to it.

Thank you very much for your time.

Carroll Rinehart