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 addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗