Daily challenge · Monday 2 March 2026HARD
Rebuild the launch timeline
PMO needs a working-day schedule that offsets each task from the project start, calculates finish dates, and counts the effort in working days.
Goal
Use WORKDAY to derive start and finish dates that skip weekends, then NETWORKDAYS to calculate working time for every task.
Anchor your WORKDAY formulas off J1. Start dates use the offset in column C; finish dates add duration minus one day. NETWORKDAYS between the start and finish will return the working-day count.