Please consider adding a lock function to link two cells together by that fix number of days.
Let Cell A be preceding Cell B, Cell B not preceding but "linked/locked" with Cell C (Cell C happens before Cell B).
So that when Cell A shifts backwards, Cell B also shifts backwards, and Cell C also shifts backwards, due to a PULL from Cell B.