linking tabs in excel

Question

have linked 2 tabs on a document so when I change the first on it automatically changes the other one which shows +7 days. Occasionally I only want it to be +5 and +2 days how can I do that.

Answer 1

If one sheet is always “+7 days” from another, the second sheet probably uses a formula like:

=Sheet1!A1 + 7

To sometimes use +5 or +2 instead of +7, replace the hard‑coded 7 with a cell that holds the offset you want.

Example setup:

1. On the second sheet (the one that shows the shifted date), pick a cell for the offset, for example B1.
2. Type the number of days you want there:
   • 7 for +7 days
   • 5 for +5 days
   • 2 for +2 days
3. In the date cell on the second sheet (say A1), use:

      =Sheet1!A1 + B1
   

Now:

• Changing the original date on Sheet1 will still update Sheet2 automatically.
• Changing B1 between 7, 5, or 2 will switch between +7, +5, or +2 days without breaking the link.

If the link was created by copying a cell from the first sheet and using Paste Link, edit the resulting formula in the formula bar to add the offset cell instead of a fixed +7.

---

References:

• Enter data manually in worksheet cells
• Create workbook links
• Work with links in Excel