Esc

↑↓ move↵ openIndex · Pagefind

Construction schedule template with a Gantt chart that calculates.

List activities, durations and predecessors. The sheet works out start and finish dates on working days, runs a backward pass for total float, marks the critical activities and draws the bars with conditional formatting.

  • Free
  • No signup
  • Excel · Google Sheets · LibreOffice
The Excel file

What’s in the workbook

The download is one Excel file (147 KB) with 2 sheets: Instructions, Schedule. The formulas are live, the inputs are marked, and it opens in Excel for Windows and Mac, Excel for the web, Google Sheets and LibreOffice. This is the Schedule sheet with the sample data:

J10Formula in J10: =IF($A10="","",MAX($F$2,IF(F10="",0,IFERROR(WORKDAY(INDEX($K$5:K9,MATCH(F10,$A$5:A9,0)),IF(N(E10)=0,0,1)+G10),0)),IF(H10="",0,IFERROR(WORKDAY(INDEX($K$5:K9,MATCH(H10,$A$5:A9,0)),IF(N(E10)=0,0,1)+I10),0))))
Construction schedule (Gantt) template: preview of the “Schedule” sheet in construction-schedule-gantt-template.xlsx, with the sample data
ABEFJKMTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBM
1Construction schedule (Gantt)
2ProjectRiverside clinic building (sample)Project start3/2/2026Finish1/7/2027Critical
3Blue cells on yellow are inputs. List activities in logical order: a predecessor must sit above its successor. Start, finish, float and the bars are formulas. Durations and lags are working days (Monday to Friday). Orange bars are critical (zero float), green shows % complete.
4IDActivityDuration (workdays)Predecessor 1StartFinishTotal float (days)Mar 2Mar 9Mar 16Mar 23Mar 30Apr 6Apr 13Apr 20Apr 27May 4May 11May 18May 25Jun 1Jun 8Jun 15Jun 22Jun 29Jul 6Jul 13Jul 20Jul 27Aug 3Aug 10Aug 17Aug 24Aug 31Sep 7Sep 14Sep 21Sep 28Oct 5Oct 12Oct 19Oct 26Nov 2Nov 9Nov 16Nov 23Nov 30Dec 7Dec 14Dec 21Dec 28Jan 4Jan 11
5A1000Mobilize and site setup53/2/20263/6/20260
6A1010Clearing and erosion control5A10003/9/20263/13/20260
7A1020Excavation and footings15A10103/16/20264/3/20260
8A1030Underslab plumbing and electrical8A10204/6/20264/15/20260
9A1040Slab on grade6A10304/16/20264/23/20260
10A1050Structural steel erection20A10404/29/20265/26/20260
11A1060Metal deck and level 2 slab10A10505/27/20266/9/20260
12A1070Roofing12A10606/10/20266/25/202615
13A1080Exterior framing and sheathing15A10606/10/20266/30/20260
14A1090Windows and storefront12A10807/1/20267/16/20260
15A1100Building dried in0A10707/16/20267/16/20260
16A1110Interior framing15A11007/17/20268/6/20260
17A1120MEP rough-in25A11108/7/20269/10/20260
18A1130In-wall and above-ceiling inspections3A11209/11/20269/15/20260
19A1140Insulation and drywall20A11309/16/202610/13/20260
20A1150Ceiling grid and tile10A114010/14/202610/27/202617
21A1160Paint12A114010/21/202611/5/20260
22A1170Flooring10A116011/6/202611/19/20260
23A1180MEP trim and fixtures12A115011/20/202612/7/20260
24A1190Site paving and landscaping15A11007/31/20268/20/202687
25A1200Elevator installation25A10606/24/20267/28/2026112
26A1210Commissioning and TAB10A118012/8/202612/21/20260
27A1220Punch list8A121012/22/202612/31/20260
28A1230Final inspections and TCO5A12201/1/20271/7/20270
29A1240Substantial completion0A12301/7/20271/7/20270
InstructionsSchedule
Rendered from the downloadable file: same formulas, same sample numbers, same conditional formatting. Sample data is illustrative.

Sheets

Instructions
How the dates, float and bars are calculated, and the limits of a spreadsheet schedule.
Schedule
40 activity rows with drop-down predecessors, working-day dates, late finish, total float, a critical flag, a predecessor check and a 52-week Gantt drawn by conditional formatting.

Built in

  • Live formulas: change an input and every total, flag and chart updates
  • Frozen header rows and columns, so labels stay put as you scroll
  • Drop-down lists and value checks on the input cells
  • Conditional formatting for flags and overruns, and the Gantt bars themselves
  • An Instructions sheet with every column defined
  • Prints landscape, one page wide, with the header row repeated
Download the .xlsx
Worked example (illustrative)

Worked example: a clinic building in 25 activities

Illustrative schedule from the sample file. Work starts 3/2/2026, and 25 activities with finish-to-start links finish on 1/7/2027. 21 of them are critical.

The envelope shows how float works. Roofing and the exterior framing then windows chain both follow the level 2 slab, and both must finish before the building is dried in. Framing and windows together take 27 working days; roofing takes 12, so roofing carries 15 days of total float and its bar is blue, not orange.

Site paving has 87 days of float and the elevator 112. Both can slip without moving substantial completion, which is why they feed the punch list and final inspections as second predecessors. Steel erection is 60% complete, so the first part of its bar is green.

The formulas in the file

StartSchedule · J10

=IF($A10="","",MAX($F$2,IF(F10="",0,IFERROR(WORKDAY(INDEX($K$5:K9,MATCH(F10,$A$5:A9,0)),IF(N(E10)=0,0,1)+G10),0)),IF(H10="",0,IFERROR(WORKDAY(INDEX($K$5:K9,MATCH(H10,$A$5:A9,0)),IF(N(E10)=0,0,1)+I10),0))))

The later of the project start and each predecessor’s finish plus one working day plus the lag, found among the rows above.

FinishSchedule · K10

=IF($A10="","",IF(N(E10)=0,J10,WORKDAY(J10,E10-1)))

Start plus duration minus one working day; a milestone finishes on its start date.

Late finishSchedule · L12

=IF($A12="","",MIN(IF(COUNTIF(F13:$F$44,$A12)=0,$K$2,MINIFS(R13:$R$44,F13:$F$44,$A12)),IF(COUNTIF(H13:$H$44,$A12)=0,$K$2,MINIFS(S13:$S$44,H13:$H$44,$A12))))

The earliest limit set by any successor below (its late start minus one working day minus the lag), or the project finish.

Total floatSchedule · M12

=IF($A12="","",NETWORKDAYS(K12,L12)-1)

Working days between finish and late finish. Zero marks the activity critical.

Gantt bar (conditional formatting)Conditional formatting

=AND($A5<>"",T$4<=$K5,T$4+6>=$J5)

Shades a week column when the week overlaps the activity’s start and finish; critical bars use the orange rule above it.

Construction schedule (Gantt) template: printable version

os.construction · free template
Project
Project start
Finish
Prepared by

Schedule (sample activities)

IDActivityDuration (workdays)Predecessor 1Lag 1 (days)StartFinishTotal float (days)Critical
A1000Mobilize and site setup53/2/20263/6/20260Yes
A1010Clearing and erosion control5A10003/9/20263/13/20260Yes
A1020Excavation and footings15A10103/16/20264/3/20260Yes
A1030Underslab plumbing and electrical8A10204/6/20264/15/20260Yes

Sample rows are illustrative and marked for deletion. Your contract, drawings and specifications govern. Template from os.construction/resources/templates/construction-schedule-gantt

How to use it

Using the construction schedule (Gantt) template

  1. Set the project start to a working day. Dates count Monday to Friday; holidays are not excluded, so add them to durations.
  2. List activities in the order the work happens, one row each, with a unique ID and a duration in working days. Use a duration of 0 for milestones such as dry-in or substantial completion.
  3. Link each activity to up to two predecessors from the drop-down, with a lag where the successor has to wait (cure time, review time). A predecessor must be listed above its successor.
  4. Read the result: orange bars are critical (zero total float) and drive the finish date; blue bars have float. Update % complete each week and the bar fills in green.
  5. Use it to plan a small job, show a bid schedule or test a sequence. A contract schedule with calendars, start-to-start logic and resources belongs in a CPM tool.
How the sheet schedulesActivities and durations, then Predecessors and lags, then Forward pass, then Backward pass, then Total float, then Gantt bars.Activities and durationsWorking days, 0 for milestonesPredecessors and lagsFinish-to-startForward passStart and finish datesBackward passLate finish from successorsTotal floatZero = criticalGantt barsConditional formatting
  1. Activities and durationsWorking days, 0 for milestones
  2. Predecessors and lagsFinish-to-start
  3. Forward passStart and finish dates
  4. Backward passLate finish from successors
  5. Total floatZero = critical
  6. Gantt barsConditional formatting
How the sheet schedules
Text version
  1. Activities and durations: Working days, 0 for milestones
  2. Predecessors and lags: Finish-to-start
  3. Forward pass: Start and finish dates
  4. Backward pass: Late finish from successors
  5. Total float: Zero = critical
  6. Gantt bars: Conditional formatting
In os.construction

Do this in os.construction instead of a spreadsheet

The CPM Planner in os.construction is a native critical path workspace with a P6-validated engine: WBS, calendars, finish-to-start, start-to-start, finish-to-finish and start-to-finish logic with lags, P6 constraints, progress and baselines, in a grid and Gantt with float, progress and longest-path focus. You can paste activities from Excel or round-trip the activity table through Excel, so a schedule started in this template can move across. Why this date? traces explain what drives any activity, and Primavera P6 XER and Microsoft Project XML files import with their logic.

Try it on the sample project

Every trial workspace includes a sample project to run this workflow on. 14-day free trial. Pricing for paid plans isn't set yet.

FAQ

Questions about the construction schedule (Gantt) template

How do I make a construction schedule in Excel?

List the activities in the order the work happens, give each a duration in working days and link it to the activity it waits for. Start dates come from the predecessor’s finish plus a lag, finish dates from start plus duration, and conditional formatting draws a bar across week columns between the two. This template has those formulas built in.

Does this template calculate the critical path?

Yes, in a simplified way. It runs a forward pass for early dates and a backward pass from the project finish for late finish dates, then flags activities with zero total float as critical. It supports finish-to-start links with lags and up to two predecessors per activity; it has no calendars, constraints or start-to-start logic.

Why must a predecessor be listed above its successor?

Each row only looks up the rows above it for its predecessors and the rows below it for its successors. That keeps the sheet free of circular references without macros. The Check column warns you when a predecessor is listed out of order.

Why does late finish show #NAME? in my Excel?

Late finish uses MINIFS, which needs Excel 2019, Microsoft 365, Excel for the web, Google Sheets or LibreOffice. In Excel 2016 and earlier, the dates and bars still work; float and the critical flags will not.

When should I move to scheduling software?

When the schedule is a contract document, has more than a few dozen activities, needs calendars, start-to-start or finish-to-finish logic, resources or a baseline to report against, or has to be updated and analyzed every month. That is the job of a CPM scheduling tool.

Keep going

Open file