Linking excel cells on different tabs

Question

How can I link 2 tabs on a spread sheet both have a drop down with weekly dates. When I change the week date on the first tab I want it to automatically change the date on the other tab. However, the second tab date will be one week on so +7 days. Many thanks

Answer 1

Use a formula on the second tab that references the first tab’s date cell and adds 7 days.

Assume:

• First tab is named Week1 and the date dropdown is in cell B2.
• Second tab is named Week2 and the date should appear in cell B2.

On the second tab (Week2), in cell B2, enter:

=Week1!B2+7

Key points:

• Week1!B2 links to the date on the first tab.
• +7 makes it one week later.
• If the sheet name has spaces or special characters, wrap it in single quotes, for example:

    ='Week 1'!B2+7
  

• Make sure the cell on the second tab is formatted as a Date so it displays correctly.

Now, whenever the dropdown date on the first tab changes, the second tab will automatically update to show the date 7 days later.

---

References:

• Create or change a cell reference