Excel Gantt Chart Schedule Template: Build, Format, and Use

An Excel Gantt chart schedule template combines a task list with a dated timeline, then uses conditional formatting to draw a bar across the dates when each task is planned. In Microsoft Excel for Microsoft 365 on Windows, you can build one from a blank worksheet with task names, start and finish dates, and a simple conditional-formatting rule.

What an Excel Gantt chart template shows

A Gantt chart is a visual schedule: tasks appear in rows, dates run across columns, and horizontal bars show when work is planned. It helps readers see timing, overlap, gaps, and the overall shape of a project. Unlike a dedicated project-management system, a basic Excel chart does not automatically understand every dependency or reschedule later tasks when a date changes. Its accuracy depends on the information and rules you put in the worksheet.

A practical template has two parts:

Task table: task name, owner, start date, finish date, duration, and optionally status or notes.
Timeline: one column for each day, week, or month, with formatted cells marking the span of each task.

For example, a small website project might include “Approve wireframes,” “Build landing page,” and “Review content.” If development begins before all content is final, the bars can overlap and make that handoff visible. The chart communicates the plan; it does not prove that the dates are achievable or that a task is complete.

Set up the worksheet layout

Start with a blank worksheet and reserve the first columns for task information. A useful layout is:

Column A: Task
Column B: Owner
Column C: Start date
Column D: Finish date
Column E: Duration
Column F: Status or notes
Column G onward: timeline dates

Put column headings in row 3 and enter the first task in row 4. Use actual Excel dates in columns C and D, not text that merely looks like a date. For a sample schedule, enter November 2, 2026, as the start and November 6, 2026, as the finish of the first task. Set the date in G3 to November 2, 2026, and make the next timeline date one day later. Format the date cells so they are readable; a compact format such as 2-Nov is often easier to scan than a long date.

Before adding bars, decide how much timeline to show. A two-week plan may work well with daily columns. A multi-month plan can become too wide, so weekly columns may be more useful. The date scale should match the decisions readers need to make: a weekly plan often does not need to show every hour, while a short event schedule may need daily detail.

Build the timeline and duration calculations

Enter the project’s first timeline date in G3. With that date in G3, put this formula in H3 to advance the timeline by one calendar day: =G3+1. The result is November 3, 2026, when G3 contains November 2, 2026. Copy H3 to the right to fill subsequent dates. If the schedule uses weekly columns, use a seven-day increment instead; with the first week’s date in G3, the next column can use =G3+7.

To calculate inclusive calendar-day duration, with start dates in C4:C20, finish dates in D4:D20, and the first task on row 4, enter this in E4: =D4-C4+1. For a start date of November 2 and finish date of November 6, the result is 5 days. The plus one counts both the start and finish dates. Fill the formula down for the other tasks. This is calendar duration, so weekends count.

If your duration should count Monday through Friday rather than calendar days, with the same start and finish date columns, enter this in E4: =NETWORKDAYS(C4,D4). For November 2–6, 2026, the result is 5 working days. NETWORKDAYS can also take a range of holiday dates as a third argument, which excludes listed holidays from the count. Choose one convention and label it clearly; a five-calendar-day task and a five-working-day task do not occupy the same span in every schedule.

Draw schedule bars with conditional formatting

Conditional formatting makes the timeline respond to each task’s dates. Select the intended chart area, such as G4:AZ20, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. With dates in row 3, task start dates in column C, and finish dates in column D, use this rule formula: =AND(G$3>=$C4,G$3<=$D4). Choose a fill color for the bar and confirm the rule.

The formula checks whether the date at the top of the current timeline column falls between the start and finish dates for the task on that row. The dollar signs keep the date header on row 3 and the task dates in columns C and D as the rule is applied across the grid; the row number for the task can change as the rule moves down. If you select a different starting cell or use a different layout, adjust the references to match it. In the formula bar or rule dialog, type ordinary comparison symbols such as >= and <=; the HTML entities above display those symbols in this article.

In Excel for Microsoft 365 on Windows, the rule dialog includes a formula option and a formatting control. On Mac, the same conditional-formatting approach is available from Home > Conditional Formatting > New Rule, though dialog labels and layout can differ. Excel for the web also supports conditional formatting, but some rule-editing details may be presented differently. If the bars do not appear, check that the task dates are real dates, the rule’s “Applies to” range begins on the same row used in its formula, and the start date is not later than the finish date.

Make the template easier to read and maintain

Good formatting lets someone understand the schedule without decoding a crowded grid. Freeze the task headings and the task-name columns so they remain visible while scrolling. In Excel for Windows, select the cell below and to the right of the rows and columns you want to keep visible, then use View > Freeze Panes > Freeze Panes. For example, selecting G4 freezes the top three rows and the first six columns. On Mac, use the Freeze Panes command on the View tab; the available choices depend on the selected cell.

Other useful improvements include:

Use a distinct fill for the timeline bars and a different style for milestone dates.
Apply a readable date format to the timeline headers, and make the columns narrow enough to show the project span without wasting space.
Turn on filters for the task headings with Home > Sort & Filter > Filter when readers need to find tasks by owner or status.
Use a consistent status vocabulary, such as Not started, In progress, and Complete, rather than mixing several descriptions.
Add a note or legend that explains the date scale, whether duration includes weekends, and what the bar color represents.

For a long schedule, consider displaying weeks rather than days or dividing the work into separate worksheets by phase. You can also shade weekends with an additional conditional-formatting rule. With timeline dates in row 3, apply this rule to G4:AZ20: =WEEKDAY(G$3,2)>5. Choose a subtle fill, and make sure it does not make task bars difficult to see. Multiple conditional-formatting rules can interact, so review the rules and their order if one format hides another.

Show progress without confusing it with the plan

A planned bar shows the dates assigned to a task, not how much work is finished. A task can remain visually scheduled even if it is delayed, complete, or not yet started. Keep actual status in a separate column, and update it deliberately. If readers need to compare planned and actual timing, add actual start and finish columns or use a separate visual treatment; do not imply that a filled planned bar is proof of completion.

You can use a separate progress field as a percentage, but agree on what the percentage means. “50% complete” can refer to effort spent, deliverables accepted, or work remaining, and those measures are not interchangeable. For a simple schedule, a status label is often more honest and easier to maintain than a precise-looking percentage. If a task’s dates change, update the dates in the task table and check whether downstream tasks should move too.

Common template problems and how to avoid them

Bars are missing: confirm the conditional-formatting range and cell references, and check that dates are stored as Excel dates rather than text.
The bar is one day too long or short: decide whether finish dates are inclusive. The duration formula with +1 treats both endpoints as scheduled days.
The schedule ignores weekends: calendar-date bars include every date unless you choose a workday-based design. NETWORKDAYS counts weekdays for duration, but it does not by itself redraw the timeline to skip weekend columns.
Dates stop before the last task: extend the timeline columns far enough to include the latest finish date.
A changed task does not move later tasks: the basic template is a visual calendar, not a dependency engine. Update dependent dates manually or use software that supports linked tasks and automatic rescheduling.
Printing cuts off the chart: use landscape orientation, check the print preview, and consider printing a shorter date range or separate project phases. Scaling a very wide chart to one page can make text unreadable.

Protect the sheet only after the layout is settled, and leave the date-entry cells editable if other people maintain the schedule. Keep a backup before making large changes to rules or formulas. When multiple people edit a workbook, agree who owns the dates and how often the plan is updated; otherwise, a polished chart can quickly become an outdated one.

When Excel is the right choice—and when it is not

An Excel Gantt chart is a sensible choice for a small or moderately sized plan when the team already uses spreadsheets, the schedule is reviewed periodically, and manual updates are manageable. It is flexible, familiar, and can be adapted to a project’s own labels and reporting needs. A template also makes a useful one-page overview for a meeting or a straightforward schedule that does not require automated dependency management.

A dedicated project-planning tool may be a better fit when the plan has many linked tasks, resource conflicts, frequent replanning, baselines, or several people updating work at once. Those systems commonly provide dependency views and collaboration features that a hand-built worksheet does not provide automatically. A spreadsheet can still serve as an export or summary, but avoid treating a colored grid as a substitute for a maintained project plan.

Frequently Asked Questions

Does Excel have a built-in Gantt chart template?

Excel may offer schedule or project templates through its template gallery, with available choices varying over time and by installation. You can also create the core Gantt layout in a blank workbook using a task table, date headers, and conditional formatting. A blank-sheet version is easier to tailor when you want a particular date scale or set of columns.

Can Excel create a Gantt chart automatically from start and finish dates?

Excel does not automatically infer a complete project schedule from those dates in a basic worksheet. A conditional-formatting rule can color the cells between each task’s start and finish dates, as described above, but it will not automatically create logical dependencies or move other tasks when one date changes.

Should a Gantt chart use working days or calendar days?

Use the scale that matches the work and the decisions readers need to make. Calendar days are clear for events, leave periods, or delivery windows that include weekends. Working-day counts suit weekday-based effort estimates, but you must still decide whether weekends appear on the visual timeline or are omitted from it.

How do I update the chart when a task date changes?

Change the task’s start or finish date in the task table. If the conditional-formatting rule covers that row and the timeline includes the new date, the bar should update. Then check any tasks that depend on it, because the basic template will not shift those dates automatically.

Can I use the same Gantt template in Excel for Mac or the web?

The basic layout, date arithmetic, and conditional-formatting idea work in current Excel versions on Mac and in Excel for the web, although menus and dialogs can differ. Use the Home tab’s Conditional Formatting controls to create or edit the rule. If a workbook is shared across versions, confirm that the rules and print layout still display as intended for its users.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.