I am hoping I can get some help here. If you see on the attach spreadsheet.
I am wanting for the Calendar dates to automatically populate on another sheet.
If you look at the Sheet called Schedule and see Cell B3 & B4 for the Start and End Date.
I would like whatever dates I enter to be populated on Sheets called Internal, Operations, Executive & Customer.
I currently have a formula on the Internal Sheet, on Cell D3 and E3 that gives me the calendar scheduled by me having to copy the formula across, for it to function. But normally the customer working on this spreadsheet will get it blank as in the Operation sheet and once they enter the dates on Schedule sheet I would like for the calendar dates to automatically update on the sheets according to the start and end dates put on the Schedule Sheet, with a +7 date per Cell.
Hope this makes sense!! Thank you and look forward to your help.WW Working Book v1.4.xlsx
Bookmarks