Constructelligence
Overview
Free tools Pricing Demo Join the beta
Template · scheduling

Construction schedule template: activities, workday finish dates and a free Excel download

A construction schedule lists the activities that build the job, how long each takes, what each depends on and when it starts and finishes. A spreadsheet will not replace Primavera P6 or Microsoft Project on a large job — it cannot calculate a critical path through hundreds of links — but for a small job, a subcontractor's own work or a weekly look-ahead it is often what actually gets updated. This template does the date arithmetic for you: enter the start and the duration in workdays, and the finish date skips weekends; mark status and percent complete, and days late count themselves.

Updated · 8 minute read

Key takeaways
  • Durations in workdays; finish = WORKDAY(start, duration − 1).
  • Every activity follows something — logic is what makes a schedule useful.
  • Update progress weekly from the field, not from cost.
  • Milestones are what the owner reads: report their movement the week it happens.

What a construction schedule needs

For logic beyond a simple chain — several predecessors, lags, float — see the critical path method guide, and the scheduling software guide for when to move to P6 or Project.

A filled-in example

The first six activities for Maple Street Medical Office:

IDActivityWorkdaysAfterStartFinishStatus
A100Mobilize & layout3—Mon Nov 2Wed Nov 4Complete
A110Excavate & pour footings12A100Thu Nov 5Fri Nov 20In progress (60%)
A120Steel erection15A110Mon Nov 23Fri Dec 11Not started
A130Roofing8A120Mon Dec 14Wed Dec 23Not started
A140MEP rough-in, floor 120A120Mon Dec 14Fri Jan 8Not started
M1Dry-in (milestone)1A130Thu Dec 24Thu Dec 24Not started

Steel erection runs through Thanksgiving week. WORKDAY only skips weekends unless you give it a holiday list — add one (a range of dates as WORKDAY's third argument) before trusting December dates.

CalculatorWhat a late finish costs

Updating it every week

  1. Same day every week: update % complete and status from the superintendent, not from cost.
  2. For anything that started late or is running long, change its Start or Duration — then move its successors' starts to the day after its new finish.
  3. Read the milestones: if dry-in moved, the owner should hear it from you this week.
  4. Filter out Complete and sort by Finish: the next three weeks is your look-ahead.

How to fill it in

  1. Enter activities in order of work, with an ID, phase, trade and duration in workdays.
  2. Give every activity except the first a predecessor ID, and set its Start to the workday after that predecessor's Finish.
  3. Finish dates calculate from Start and Duration, skipping weekends (add holidays in WORKDAY if you need them).
  4. Each week, update % complete and Status; Days late counts workdays past Finish for anything not complete.
  5. Filter Status ≠ Complete and sort by Finish for the look-ahead.
Checklist
Construction schedule template in Excel, filled in with example rows — columns: ID, Phase, Activity, Trade / crew, Duration (workdays), Predecessor ID, Start, Finish…
The construction schedule template as it opens in Excel: example rows in italics, calculated columns shaded.
Free template · Construction schedule template (Excel & CSV)An Excel workbook with drop-downs, validation and formulas built in — or the same columns as a CSV for Google Sheets and Numbers.
Download Excel (.xlsx)
What this template captures

The data a construction schedule needs to be updated weekly and read at a glance: each activity's phase, trade, duration, the activity it follows, its dates, progress, status and whether it is a milestone — with finish dates and days late calculated, so nobody does date arithmetic by hand.

13 columns: 9 you fill in, 2 picked from drop-down lists, so every row uses the same values and 2 calculated by formula and filled down 200 rows, so nothing is worked out by hand. In the Excel version, 3 columns reject entries of the wrong type (a date column only takes dates, an amount column only numbers), the header row stays frozen with filters on it, and the workbook opens on an Instructions sheet that lists every column below.

Every column, and how it is captured
ColumnTypeWhat goes in it
IDTextActivity ID (A100, A110…) — predecessors refer to it.
PhaseTextPhase of the work (e.g. underground, rough-in, trim).
ActivityTextThe schedule activity or scope of work.
Trade / crewTextWho performs the activity.
Duration (workdays)NumberWorking days the activity takes; weekends are skipped by the finish formula.
Predecessor IDTextThe ID of the activity that has to finish before this one starts.
StartDatePlanned start — or, once started, the actual start. Use the predecessor's finish + 1 workday.
FinishCalculatedCalculated — start plus duration in workdays, skipping weekends (= IF([Start]=blank, blank, WORKDAY([Start], [Duration (workdays)] − 1)))
% completePercentPhysical percent complete, 0–100, from the field — not cost spent.
StatusDrop-downWhere the item stands; pick from the list so the log can be filtered and counted. Options: Not started / In progress / Complete / On hold.
Milestone?Drop-downYes for dates the owner or contract cares about (dry-in, substantial completion). Options: Yes / No.
Days lateCalculatedCalculated — workdays past the finish date for any activity not complete (= IF(OR([Finish]=blank, [Status]="Complete"), 0, MAX(0, NETWORKDAYS([Finish], TODAY()) − 1)))
NotesTextAnything that explains the row; free text.

See it on real-looking numbers

Constructelligence is a construction intelligence platform: it reads your ERP, project and field systems read-only and does this arithmetic every week, for every job. The demo runs it on a sample eight-job portfolio.

Try the demoJoin the private beta

Frequently asked questions

How do I make a construction schedule in Excel?

List activities with an ID, duration in workdays and the activity each follows. Enter each start date as the workday after its predecessor's finish and calculate finish with =WORKDAY(start, duration − 1). Add percent complete and status columns and update them weekly.

What is the difference between a construction schedule and a Gantt chart?

The schedule is the data — activities, durations, logic and dates. A Gantt chart is one way of drawing it, as bars on a timeline. Most scheduling software shows both.

When should I use scheduling software instead of a spreadsheet?

When activities have several predecessors, when you need the critical path and float calculated, or when the owner's contract requires a CPM schedule in P6 or Microsoft Project format.

How often should a construction schedule be updated?

Weekly on an active job, on the same day, with progress from the field — and the critical path and milestones re-checked each time.

CI
Written by the Constructelligence teamConstruction finance and software. Worked examples use the sample demo portfolio; formulas are standard practice. Reviewed September 2026.
The critical path method in construction, worked through one scheduleHow the critical path method works on a construction schedule: forward and backward pass, total and free float, what a delay does to the finish, and the checks that keep a CPM schedule honest.The three-week look-ahead schedule: build it, run it, measure itHow to build and run a three-week look-ahead schedule in construction: pulling work from the CPM schedule, clearing constraints, the weekly meeting, and measuring percent plan complete (PPC).Construction scheduling software: Primavera P6, Microsoft Project and the restConstruction scheduling software compared — Primavera P6, Microsoft Project, Asta Powerproject, Smartsheet and linear scheduling — when each fits, what a healthy schedule looks like, and the DCMA checks.

More in Templates & forms

All templates & forms resources →