Excel Task Scheduling Formulas

$10-30 USD

Posted 1 minute ago

•

Ends in 6 days

$10-30 USD

Paid on delivery

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.

Project ID: 40816508

About the project

1 proposal

Open for bidding

Remote project

Active 57 yrs ago

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

把喜欢的内容,留在你的新标签页。

打开我的订阅