Template · Management
Project Gantt chart with dependencies and milestones
Task schedule with predecessors, lags and milestones, and a weekly Gantt that moves when dates or progress change.
Downloads are included in the $19.85 yearly membership. Sign in
XLSXCSVODSXMLNumbers| Project Gantt chart | |||||||||||
| Example data — replace the blue input cells with your own. | |||||||||||
| PROJECT FINISH | COMPLETE | TASKS LATE | NEXT MILESTONE | ||||||||
| Dec 14, 2026 | 49% | 3 | Equipment delivered | ||||||||
| 134 calendar days from the start | Duration-weighted | 8 of 28 done | Nov 10, 2026 | ||||||||
| Settings | |||||||||||
| Project start (a Monday) | Aug 3, 2026 | The Gantt starts on the Monday on or before this date. | |||||||||
| Status date | Oct 9, 2026 | A task past its finish date and under 100% complete is Late. | |||||||||
| Progress by phase | |||||||||||
| Phase | Tasks | Complete | Progress (duration-weighted) | ||||||||
| 1. Design | 6 | 100% | ████████████████████ | ||||||||
| 2. Approvals | 3 | 86% | █████████████████░░░ | ||||||||
| 3. Procurement | 4 | 77% | ███████████████░░░░░ |
Showing the first 16 of 43 rows and 12 of 27 columns. Cells with formulas show the formula on hover.
| Tasks and dependencies | |||||||||||
| One row per task. Start and finish are formulas from predecessors, lags and requested dates. | |||||||||||
| List each predecessor in a row above the task that needs it. Keep each phase in one block of rows. Start, finish, status and check are formulas; the status date and project start are on the Dashboard. | |||||||||||
| ID | Phase | Task | Owner | Duration (calendar days) | Predecessor ID | Lag (days) | Requested start | Milestone? | Start | Finish | % complete |
| T01 | 1. Design | Confirm brief and room schedule | Clinic manager | 5 | 0 | No | Aug 3, 2026 | Aug 7, 2026 | 100% | ||
| T02 | 1. Design | Concept design | Architect | 10 | T01 | 0 | No | Aug 8, 2026 | Aug 17, 2026 | 100% | |
| T03 | 1. Design | Design development | Architect | 15 | T02 | 0 | No | Aug 18, 2026 | Sep 1, 2026 | 100% | |
| T04 | 1. Design | Building services design | Services engineer | 12 | T03 | 0 | No | Sep 2, 2026 | Sep 13, 2026 | 100% | |
| T05 | 1. Design | Cost check against budget | Quantity surveyor | 4 | T03 | 0 | No | Sep 2, 2026 | Sep 5, 2026 | 100% | |
| T06 | 1. Design | Design freeze | Project manager | 0 | T04 | 0 | Yes | Sep 14, 2026 | Sep 14, 2026 | 100% | |
| T07 | 2. Approvals | Lodge building permit application | Architect | 2 | T06 | 0 | No | Sep 15, 2026 | Sep 16, 2026 | 100% | |
| T08 | 2. Approvals | Authority review | Local authority | 20 | T07 | 0 | No | Sep 17, 2026 | Oct 6, 2026 | 85% | |
| T09 | 2. Approvals | Permit granted | Project manager | 0 | T08 | 0 | Yes | Oct 7, 2026 | Oct 7, 2026 | 0% | |
| T10 | 3. Procurement | Tender documents | Quantity surveyor | 8 | T06 | 0 | No | Sep 15, 2026 | Sep 22, 2026 | 100% | |
| T11 | 3. Procurement | Tender and contractor appointment | Project manager | 15 | T10 | 0 | No | Sep 23, 2026 | Oct 7, 2026 | 90% |
Showing the first 16 of 66 rows and 12 of 16 columns. Cells with formulas show the formula on hover.
| Gantt chart by week | |||||||||||
| Weekly bars for each task, milestone diamonds, the status-date marker and phase summaries. | |||||||||||
| Each row follows the Tasks row of the same position. Blue blocks are weeks a task overlaps; diamonds are milestones; the red arrow is the status date. | |||||||||||
| Week starts (Monday) | Aug | Aug | Aug | Aug | Aug | Sep | Sep | Sep | Sep | ||
| Task | Phase | Start | 3 | 10 | 17 | 24 | 31 | 7 | 14 | 21 | 28 |
| Status date | |||||||||||
| T01 Confirm brief and room schedule | 1. Design | Aug 3, 2026 | █ | ||||||||
| T02 Concept design | 1. Design | Aug 8, 2026 | █ | █ | █ | ||||||
| T03 Design development | 1. Design | Aug 18, 2026 | █ | █ | █ | ||||||
| T04 Building services design | 1. Design | Sep 2, 2026 | █ | █ | |||||||
| T05 Cost check against budget | 1. Design | Sep 2, 2026 | █ | ||||||||
| T06 Design freeze | 1. Design | Sep 14, 2026 | ◆ | ||||||||
| T07 Lodge building permit application | 2. Approvals | Sep 15, 2026 | █ | ||||||||
| T08 Authority review | 2. Approvals | Sep 17, 2026 | █ | █ | █ | ||||||
| T09 Permit granted | 2. Approvals | Oct 7, 2026 | |||||||||
| T10 Tender documents | 3. Procurement | Sep 15, 2026 | █ | █ |
Showing the first 16 of 75 rows and 12 of 29 columns. Cells with formulas show the formula on hover.
| Project Gantt chart: notes |
| Notes: what this workbook does, how to use it and the method behind it. |
| What it does |
| Schedules a project from a task list. Each task has a duration, an optional predecessor with a lag and an optional requested start. |
| Calculates start and finish dates, the status against a status date, and progress for each task, for each phase and for the whole project. |
| Draws the schedule on a weekly Gantt over 26 weeks, with a status-date marker, milestone diamonds and phase summary bars. |
| The example data is a fictional fit-out of an example clinic with 28 tasks in five phases. Status is as of October 9, 2026. |
| How to use it |
| 1. On the Dashboard, enter the project start (a Monday) and the status date. |
| 2. On the Tasks tab, enter tasks in dependency order. Each predecessor ID must sit in a row above the task that needs it. Keep each phase in one block of rows; phase 5 runs to the bottom of the list. |
| 3. Enter the duration in calendar days. For a milestone, enter Yes under Milestone? and 0 as the duration. |
| 4. Enter a predecessor ID and lag days where a task waits on another, a requested start where a date is fixed, and % complete as a fraction of the task. |
| 5. Read the Status and Check columns on the Tasks tab, then the Gantt and the Dashboard. The checks on the Dashboard should all read OK. |
Showing the first 16 of 40 rows and 1 of 1 columns. Cells with formulas show the formula on hover.
What does this template do?
A Gantt chart shows when each task of a project starts and finishes, which tasks depend on others and where the milestones fall. This workbook is for project managers, site teams and small operations groups who want a schedule that recalculates when a task slips.
Each task on the Tasks tab has a duration in calendar days, an optional predecessor with a lag, and an optional requested start. The start is the latest of the project start, the requested start, and the predecessor finish plus one day plus the lag. The finish is the start plus the duration minus one day, and a milestone finishes on its start day. Status compares the finish with the status date. The Gantt tab draws each task across 26 weeks, and the Dashboard reports the project finish, weighted progress, late tasks and the next milestones.
The example data is fictional: 28 tasks in five phases for an example clinic fit-out, with status as of October 9, 2026.
What’s inside
- Start and finish follow from predecessors, lags and requested dates
- Status is Done, In progress, Late or Not started, measured against the status date
- Weekly Gantt over 26 weeks with a status marker and milestone diamonds
- Phase summaries and a mini Gantt on the Dashboard
- Checks flag a predecessor that appears below its task or is not found
Which tabs does the workbook have?
| Tab | What it holds |
|---|---|
| Dashboard | Project finish, weighted progress, late tasks and the next milestone, with phase progress, a mini Gantt and checks. |
| Tasks | Sixty task rows with predecessors, lags, requested starts, computed dates, status and checks. |
| Gantt | A column per week for each task, phase summaries and the status-date marker. |
| Notes | What the workbook does, how to use it, the formulas, assumptions and limits. |
What formulas does this template use?
This template holds 2,668 formulas in 3,026 cells across 4 tabs, so 88% of its cells calculate. They use 20 distinct functions; the longest formula is 204 characters and 2,028 of them read from another tab.
| Function | Uses | What it does |
|---|---|---|
IF | 8,121 | one result when a test is true, another when false |
AND | 3,458 | true when every test is true |
OR | 1,966 | true when any test is true |
MATCH | 304 | position of a value in a range |
MAX | 203 | largest value |
MIN | 141 | smallest value |
ROUND | 131 | rounds to a number of digits |
REPT | 130 | repeats text |
INDEX | 79 | value at a position in a range |
IFERROR | 64 | swaps an error for a fallback value |
ISNUMBER | 60 | true for a number |
DAY | 52 | day of a date |
The 12 most used of 20 functions. Counted from the workbook itself. Only functions that Excel, LibreOffice Calc, Google Sheets and Apple Numbers evaluate the same way are used, so the formulas survive every download format.
How do you use it?
- Set the project start and the status date on the Dashboard.
- Enter tasks on the Tasks tab in dependency order, with each predecessor in a row above the task that needs it.
- Enter duration, predecessor, lag, requested start and % complete. Mark milestones Yes with a duration of 0.
- Read the Status and Check columns, then the Gantt and the Dashboard.
What is it good for?
- Scheduling a clinic or office fit-out
- Planning a software release with milestones
- Showing a client the phases, dependencies and next milestone
- Re-planning after a permit or delivery delay
Questions about this sheet
How is a task's start date calculated?
The start is the latest of the project start, the requested start, and the predecessor finish plus one day plus the lag. Each task takes one predecessor ID.
Why is a task marked Late?
A task is Late when its finish date is before the status date and its % complete is below 100%. Done means 100%.
How do I model a task that waits on two others?
Add a milestone after the second predecessor and point the task at that milestone.
Why do the Gantt columns start on a Monday?
The Gantt starts on the Monday on or before the project start, and each column is seven days.