I have a large workbook that automatically adds a new spreadsheet every week.
I'd like to add a date to the first spreadsheet and on subsequent spreadsheets have it automatically reference the date from the previous spreadsheet and add a week so it will reflect the week of the spreadsheet. I don't want to insert the 'current date' because I don't want it to change.
I thought this would be easy but I'm not finding a formula function that references another sheet dynamically. Can this be done?
Thanks in advance!
Bookmarks