excel 2007 increment date

March 28, 2011 at 13:57:37
Specs: Windows XP
Is it possible to enter a date as a relative ref across sheets in Excel 2007?
I have a date in A1 in sheet 1. If I want to reference this cell in Sheet 2 and add 7 days, it does not seem to work as I always get just the Sheet 1 ref in all the following sheets.

See More: excel 2007 increment date

Report •

March 28, 2011 at 15:28:46
How are you referencing your sheets?

On sheet 1 in cell A1: 03/28/11

On sheet 2 in cell A1: =Sheet1!A10+7 give the date 04/04/11



Report •
Related Solutions

Ask Question