Construction Schedule Template (Excel)

What it's for

This construction schedule template lays out a job as a list of tasks, each with who does it, a start date, a length in workdays and a percent complete, and draws each task across the weeks it covers. It's for the owner, project manager or superintendent who sets the order of work before the job starts, keeps the dates current to the finish and prints the plan for crews and subs.

It's a spreadsheet, not scheduling software. It has no critical path or resource leveling, and no dependencies beyond the example's chained starts. For a job that needs those, use scheduling software.

What's inside

Two sheets, both protected with no password, so a formula can't be typed over by accident.

Schedule carries our logo, then PROJECT, PROJECT START (an example date to type over), PROJECT FINISH (the latest END in the table) and UPDATED, a date nothing calculates from, beside a color key.

The table has 40 rows under NO., TASK, RESPONSIBLE, START, DURATION (WORKDAYS), END and % COMPLETE. Of those, only END calculates, though the six example starts hold formulas until you type over them. Under WEEK STARTING, 16 week columns run from the project start, 7 days apart. Conditional formatting fills each week a task's dates overlap, charcoal for scheduled work and hi-vis yellow at 100% complete. A task of 0 workdays gets ◆, never a charcoal bar. START takes only a weekday date, DURATION (WORKDAYS) only whole workdays from 0 up, and % COMPLETE only 0% to 100%.

The Schedule prints landscape on Letter paper, one page wide. About this template holds three steps, a note that the examples are placeholders, the version (v2, 2026-09-24) and links.

How to fill it in

1. Type the job at PROJECT and your start date over the example at PROJECT START. The weeks count from it, so a Monday start gives Monday-to-Sunday weeks.
2. Give each trade activity its own row, with one name under RESPONSIBLE. On a real job, the example's rough-ins would split into a row per sub. Type NO. yourself.
3. Count DURATION (WORKDAYS) as the days the crew will work, start day included. END is the last of them: a 3-workday task starting on a Monday ends on the Wednesday.
4. Give each inspection and delivery a row with a duration of 0. That makes it a milestone: it ends the day it starts, marked ◆ in its week. A blank duration isn't a milestone. It leaves END blank.
5. START and PROJECT START both refuse a Saturday or Sunday: "Start on a weekday, Monday to Friday."
6. END skips weekends but not holidays. For each holiday inside a task, or any other weekday the crew won't work, add a workday to its DURATION.
7. The 34 rows below the examples have no start formula, so type each START.
8. Once a week, update % COMPLETE on every open task, typed with the percent sign, and put the date at UPDATED. When a change order moves dates, adjust the rows it touches.

The worked example

The file opens on an example job that starts Monday, 9/14/2026, with six tasks labeled "Example:". The About tab calls their dates, durations and % complete placeholders, not typical times for the work, to replace with your own. The file computes:

Site prep starts on the project start. Each later start chains from the task above, as the next workday after it ends: site prep ends Wednesday, 9/16/2026, so foundation starts Thursday, 9/17/2026. Change a duration and every example task below it moves. Type your own date over a start and that row leaves the chain, while the rows below follow its new end.

The inspection shows ◆ in the week of 10/19, and PROJECT FINISH reads 11/5/2026. Site prep and foundation are at 100%, so their bars are hi-vis yellow. The other bars are charcoal.

Frequently asked questions