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.
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:
Formula 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))))| A | B | E | F | J | K | M | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB | BC | BD | BE | BF | BG | BH | BI | BJ | BK | BL | BM | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Construction schedule (Gantt) | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2 | Project | Riverside clinic building (sample) | Project start | 3/2/2026 | Finish | 1/7/2027 | Critical | ||||||||||||||||||||||||||||||||||||||||||||||
| 3 | Blue 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. | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 4 | ID | Activity | Duration (workdays) | Predecessor 1 | Start | Finish | Total float (days) | Mar 2 | Mar 9 | Mar 16 | Mar 23 | Mar 30 | Apr 6 | Apr 13 | Apr 20 | Apr 27 | May 4 | May 11 | May 18 | May 25 | Jun 1 | Jun 8 | Jun 15 | Jun 22 | Jun 29 | Jul 6 | Jul 13 | Jul 20 | Jul 27 | Aug 3 | Aug 10 | Aug 17 | Aug 24 | Aug 31 | Sep 7 | Sep 14 | Sep 21 | Sep 28 | Oct 5 | Oct 12 | Oct 19 | Oct 26 | Nov 2 | Nov 9 | Nov 16 | Nov 23 | Nov 30 | Dec 7 | Dec 14 | Dec 21 | Dec 28 | Jan 4 | Jan 11 |
| 5 | A1000 | Mobilize and site setup | 5 | 3/2/2026 | 3/6/2026 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 6 | A1010 | Clearing and erosion control | 5 | A1000 | 3/9/2026 | 3/13/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 7 | A1020 | Excavation and footings | 15 | A1010 | 3/16/2026 | 4/3/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 8 | A1030 | Underslab plumbing and electrical | 8 | A1020 | 4/6/2026 | 4/15/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 9 | A1040 | Slab on grade | 6 | A1030 | 4/16/2026 | 4/23/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 10 | A1050 | Structural steel erection | 20 | A1040 | 4/29/2026 | 5/26/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 11 | A1060 | Metal deck and level 2 slab | 10 | A1050 | 5/27/2026 | 6/9/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 12 | A1070 | Roofing | 12 | A1060 | 6/10/2026 | 6/25/2026 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||
| 13 | A1080 | Exterior framing and sheathing | 15 | A1060 | 6/10/2026 | 6/30/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 14 | A1090 | Windows and storefront | 12 | A1080 | 7/1/2026 | 7/16/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 15 | A1100 | Building dried in | 0 | A1070 | 7/16/2026 | 7/16/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 16 | A1110 | Interior framing | 15 | A1100 | 7/17/2026 | 8/6/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 17 | A1120 | MEP rough-in | 25 | A1110 | 8/7/2026 | 9/10/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 18 | A1130 | In-wall and above-ceiling inspections | 3 | A1120 | 9/11/2026 | 9/15/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 19 | A1140 | Insulation and drywall | 20 | A1130 | 9/16/2026 | 10/13/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 20 | A1150 | Ceiling grid and tile | 10 | A1140 | 10/14/2026 | 10/27/2026 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||
| 21 | A1160 | Paint | 12 | A1140 | 10/21/2026 | 11/5/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 22 | A1170 | Flooring | 10 | A1160 | 11/6/2026 | 11/19/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 23 | A1180 | MEP trim and fixtures | 12 | A1150 | 11/20/2026 | 12/7/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 24 | A1190 | Site paving and landscaping | 15 | A1100 | 7/31/2026 | 8/20/2026 | 87 | ||||||||||||||||||||||||||||||||||||||||||||||
| 25 | A1200 | Elevator installation | 25 | A1060 | 6/24/2026 | 7/28/2026 | 112 | ||||||||||||||||||||||||||||||||||||||||||||||
| 26 | A1210 | Commissioning and TAB | 10 | A1180 | 12/8/2026 | 12/21/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 27 | A1220 | Punch list | 8 | A1210 | 12/22/2026 | 12/31/2026 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 28 | A1230 | Final inspections and TCO | 5 | A1220 | 1/1/2027 | 1/7/2027 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 29 | A1240 | Substantial completion | 0 | A1230 | 1/7/2027 | 1/7/2027 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
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
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)
| ID | Activity | Duration (workdays) | Predecessor 1 | Lag 1 (days) | Start | Finish | Total float (days) | Critical |
|---|---|---|---|---|---|---|---|---|
| A1000 | Mobilize and site setup | 5 | 3/2/2026 | 3/6/2026 | 0 | Yes | ||
| A1010 | Clearing and erosion control | 5 | A1000 | 3/9/2026 | 3/13/2026 | 0 | Yes | |
| A1020 | Excavation and footings | 15 | A1010 | 3/16/2026 | 4/3/2026 | 0 | Yes | |
| A1030 | Underslab plumbing and electrical | 8 | A1020 | 4/6/2026 | 4/15/2026 | 0 | Yes | |
Sample rows are illustrative and marked for deletion. Your contract, drawings and specifications govern. Template from os.construction/resources/templates/construction-schedule-gantt
Using the construction schedule (Gantt) template
- Set the project start to a working day. Dates count Monday to Friday; holidays are not excluded, so add them to durations.
- 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.
- 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.
- 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.
- 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.
- Activities and durationsWorking days, 0 for milestones
- Predecessors and lagsFinish-to-start
- Forward passStart and finish dates
- Backward passLate finish from successors
- Total floatZero = critical
- Gantt barsConditional formatting
Text version
- Activities and durations: Working days, 0 for milestones
- Predecessors and lags: Finish-to-start
- Forward pass: Start and finish dates
- Backward pass: Late finish from successors
- Total float: Zero = critical
- Gantt bars: Conditional formatting
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.
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
- Pillar guideSchedule forensics guides
- Free toolCritical path calculator
- os.constructionCPM Planner and project management
- GlossaryCritical Path
- GlossaryData Date
- GlossaryFloat
- GlossaryLongest Path
- GlossaryLook-Ahead Schedule
- GlossarySchedule Baseline
- GlossaryWork Breakdown Structure
- Free resourceCritical path calculator
- Free resourceThree-week look-ahead template
- Free resourceTotal float vs free float
- TemplatePunch list template
- TemplateMeeting minutes template
- TemplateInspection checklist starter pack
- TemplateT&M ticket template
- TemplateRFI writing checklist
- TemplateDaily log checklist
- TemplateChange event log
- TemplateBack charge notice and log
- TemplateThree-week look-ahead template
- TemplateSafety observation log
- TemplateAction item tracker
- TemplateCloseout and TCO checklist
- TemplateNotice to proceed template
- TemplateJob cost report template
- TemplateChange order log template
- TemplateBid tabulation and leveling template
- TemplateCash flow projection template
- TemplateBuyout log template
- TemplateASI log template
Keep exploring
Related across os.construction
- Free toolCritical path calculatorForward and backward pass, total and free float and the critical path for your activities, with every step shown.
- ExplainerHow the critical path worksForward pass, backward pass and float on an eight-activity network, then one slip moves the critical path.
- Free toolThree-week look-ahead templateFree three-week look-ahead schedule template.
- DocsPlanning and CPM: activities, logic, calendars, constraints and progressEvery input the scheduling engine reads, from the WBS outline, activities, calendars, relationships, lags and constraints to progress, the data date and how a version is saved.
- DocsSchedule: CPM planning, field tasks and the look-aheadPlan the project in a native critical path Planner or bring in a P6 or Microsoft Project file, then publish reviewed dates to the field task list your team reads as a list, 3-week look-ahead, calendar and Gantt.
- ExplainerEarned value, step by stepPV, EV and AC S-curves on one control account: move the status date and read CV, SV, CPI, SPI and EAC.