Using Excel 2000, I have a spreadsheet that I utilize on a daily basis to keep track of opening propeties. I also receive a weekly spread sheet that is “the official” opening dates. Is there a formula that I can easily update my daily spreadsheet with date changes in “the official” spreadheet?
