Use the workbook
Show two already agreed tasks on one calendar-day timeline. This chart displays supplied starts and durations; it does not choose dependencies, exclude weekends or decide whether the schedule is feasible.
| Task | Start | Calendar days | Exclusive end |
|---|---|---|---|
| Task A | 2026-10-12 | 3 | 2026-10-15 |
| Task B | 2026-10-14 | 2 | 2026-10-16 |
Change the inputs
B5:B6 hold typed dates and C5:C6 hold durations. D5:D6 calculate the exclusive end as start+duration. The chart stacks an invisible start offset with the visible duration: intervals [0,3] and [2,4] from the base date 12 October. Change B6 to 16 October; only Task B moves two days, ending at the 18 October boundary.
Check the misleading result
A three-day task starting on 12 October occupies 12,13,14 October and ends at the start of 15 October. Adding an extra day because the endpoint is mistaken for an included workday would change the schedule. The invisible offset is positioning, not extra task duration.
After moving Task B to 16 October, do Task A’s end or either duration change?
Show the worked answer
No. Task A still ends at the 15 October boundary; durations stay 3 and 2 calendar days.