Excel Task Scheduling Formulas

I need a set of robust array formulas that turn my existing project worksheet into a self-updating schedule. The goal is simple: when I type or edit any task information, the sheet should instantly recalculate start dates, end dates, task duration, and any linked dependencies—no manual tweaking after that.

Here is what must happen inside the workbook:
• Enter or change a task’s predecessor and every connected task shifts automatically, preserving each dependency chain.
• Start date, end date, and duration always stay in sync, even when dates are edited in any order.
• A single formula block (ideally using modern functions such as LET, LAMBDA, SEQUENCE, INDEX, MATCH, or similar dynamic arrays) drives the logic so maintenance stays minimal.

If you prefer an approach that nests helper columns, I’m open to it—just keep the mechanics clear and documented in-cell or through concise comments.

Deliverable: the updated worksheet with all live formulas in place and a brief note explaining key logic so I can tweak fields in the future.