Originally Posted by
Sambo kid
Yes it makes sense. All you have to do is link all the other dates in one way or another to the date you want to change. So if the date you wanted to change is in cell A2 all you have to do is to make sure other dates have some relationship to A2. So another cell might be A2=7 so it is a week ahead. Maybe that one is in A3, then a different cell could be A3+14 so when you change A2 A3 goes ahead 7 days and A3 goes ahead 14 from A3 and 21 from A2.
You can do the same going backwards.
To get much more than that you might need to post a workbook with examples of what you want - expected results.
Bookmarks