A schedule that recalculates when the job slips
A schedule stops being useful the moment it becomes a picture of what you hoped would happen. This one is built so that moving one date moves everything downstream: enter a start and a duration in working days, and each task chains from the one before it, skipping weekends. Tasks that should have finished by today are flagged automatically.
Excel / Google Sheets compatible · no sign-up required
Three steps to a working document
Enter one start date
Only the first task needs one. Every task below it starts the next working day after the previous one finishes, using WORKDAY, so weekends are already excluded.
Set durations in working days
Seventeen typical residential tasks are pre-filled from site prep through handover, with durations you should replace with your own. Delete the trades you do not use and add the ones you do.
Break the chain where trades overlap
Type a date over the formula in any start cell and that task stops following the one above. Real jobs overlap — drywall does not wait for every inch of rough-in — and the sheet is built to let you say so.
Update the percentage complete
The status column reads it against today's date: complete, in progress, not started, or LATE. The count of late tasks sits in the summary, which is the number worth looking at on a Monday.
This is a working schedule, not a critical path analysis. It chains tasks in sequence and does not calculate float, model parallel paths or handle resource levelling — if your contract requires a CPM schedule, this is not it. Statutory holidays are not excluded either; the sheet explains how to add a holidays range to the WORKDAY formulas if you need them.
When the spreadsheet stops scaling
In BuildersBridge the schedule lives against the job with the crew assigned to each task, so a date that moves reaches the people who need to know rather than sitting in a spreadsheet on one laptop.
See how it works in BuildersBridgeCommon questions
How do I make a construction schedule?
List the tasks in the order the work actually happens, give each one a duration in working days, then chain them so each starts after the one before it finishes. Mark the tasks that can overlap and the ones that genuinely cannot — rough-in before insulation, insulation before drywall — because those are the constraints that decide the finish date.
What is a look-ahead schedule?
A short window pulled out of the full schedule, usually two or three weeks, showing only what is coming up. It is what gets discussed at a site meeting, because a full programme is too long to be useful weekly. Filter this template by date to produce one.
Does this template exclude weekends?
Yes. Every date calculation uses WORKDAY, which counts working days and skips Saturdays and Sundays. Statutory holidays are not excluded by default; the sheet shows how to add them.
Can I use this as a Gantt chart?
It gives you the dates a Gantt chart is drawn from, but not the bars. In Google Sheets or Excel you can add a stacked bar chart from the start and duration columns if you want the visual.