chrono2483
Board Regular
- Joined
- Aug 23, 2014
- Messages
- 160
Hello,
Each week, I have a worksheet document created. The naming convention is using the following week: "Week of June 14 to June 20", "Week of June 7 to 13", etc.
Within each spreadsheet, I link/reference the previous 2 week, so that I can compare week over week.
Currently, I have to manually change the date in each linked cell to pull from that spreadsheet.
Is there a formula or easier way to do this? I would like to avoid a macro if possible and just work with a formula if that can work.
Each week, I have a worksheet document created. The naming convention is using the following week: "Week of June 14 to June 20", "Week of June 7 to 13", etc.
Within each spreadsheet, I link/reference the previous 2 week, so that I can compare week over week.
Currently, I have to manually change the date in each linked cell to pull from that spreadsheet.
Is there a formula or easier way to do this? I would like to avoid a macro if possible and just work with a formula if that can work.
