A weekly Gantt chart Excel template lays out tasks against dates so you can see when work is scheduled and how long it lasts. In Microsoft Excel for Microsoft 365 on Windows, you can make a reusable version by entering task start and finish dates, adding a date row, and applying conditional formatting to shade the cells that overlap each task.
What a weekly Gantt chart shows
A Gantt chart is a schedule displayed as a grid: tasks appear in rows, time appears in columns, and bars show the periods when each task is active. A weekly chart can mean either a view of the seven days in one week or a longer plan whose columns represent whole weeks. Those views answer different questions. A daily view is useful for coordinating a short work sprint, while a week-by-week view is easier to scan for a project lasting several months.
Excel does not require a special Gantt chart object for this layout. The chart is usually a formatted worksheet: dates provide the timeline, and conditional formatting colors cells when their dates fall within task start and finish dates. Because the dates remain ordinary spreadsheet values, you can sort tasks, change dates, or expand the schedule without redrawing bars by hand.
A useful template normally includes a task name, owner, start date, finish date, duration, and timeline. Optional fields might include status, priority, or a dependency note. Keep the schedule focused on dates and coordination; a colored bar alone does not prove that a task is progressing or that a dependency has been met.
Build a simple one-week template
Start with a blank workbook and make a small table. In row 4, put the seven dates of the week in columns F through L. Use columns A through E for task information, and begin the tasks on row 5. For example, use Task in A, Owner in B, Start in C, Finish in D, and Duration in E. Format the start, finish, and timeline cells as dates so Excel recognizes them as date values rather than text.
- Enter a Monday date in F4, such as April 6, 2026. This date is a Monday.
- With F4 as the first date, enter this formula in G4 and fill it right through L4:
=F4+1. The resulting headers are April 7 through April 12. - Enter each task’s start and finish dates in columns C and D. Use the same date system as the timeline.
- With task start dates in C5:C24 and finish dates in D5:D24, enter this formula in E5 and fill down:
=D5-C5+1. A task from April 6 through April 8 returns 3 days because both endpoints are counted. - Select F5:L24, then create a formula-based conditional formatting rule using the formula described in the next section.
Adjust the number of task rows to suit the project. If you expect to add more tasks, you can select a larger range at the start, such as F5:L100. You can also convert the task list into an Excel table using Insert > Table. A table makes task records easier to filter and helps extend a structured list, although the timeline still needs to cover the rows where you want bars to appear.
Shade task dates with conditional formatting
For the selected range F5:L24, create a rule with this formula: =AND(F$4>=$C5,F$4<=$D5). In Excel for Microsoft 365 on Windows, select Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter the formula, choose a fill color with Format, and confirm the rule. Excel evaluates it for each cell in the selected range.
The formula assumes timeline dates are in F4:L4, task start dates are in C5:C24, finish dates are in D5:D24, and the first bar cell is F5. The dollar signs keep the header row and date columns fixed as the rule is applied across the grid, while the task row changes for each row. For a task starting April 6 and finishing April 8, the rule is true under April 6, 7, and 8, so those three cells are shaded. It is false under the other dates in that week.
If you change the layout, update the formula and the range together. For instance, if the first timeline date is in G4, the first task bar cell is G5, and the start and finish dates remain in C and D, the references should reflect that new starting column. An off-by-one reference is a common reason every row appears shifted by a day or the bars do not match their task dates.
Choose daily or weekly columns
A seven-column timeline gives a clear day-by-day view, but it only displays one week at a time. For a longer project, make each timeline column represent a week. Put the Monday date for each week in row 4, with the next week’s Monday in the next column. Then apply a rule to the task grid that shades a week whenever any part of the task overlaps that week.
Assuming the Monday date for the first week is in F4, task start and finish dates are in C5 and D5, and the task grid begins at F5, use this conditional-formatting formula: =AND(F$4<=$D5,F$4+6>=$C5). A week runs from the date in its header through six days later. The rule returns true when the week begins on or before the task finishes and the week ends on or after the task starts. Thus, a task that begins on Sunday and ends the following Tuesday shades both weekly columns, even though it overlaps each week for only part of its duration.
Weekly columns simplify a long-range view, but they hide exact daily timing. A task displayed in a shaded week might occupy one day or all seven, so do not treat the colored cell as a precise duration. If the schedule needs both an overview and detailed coordination, maintain a weekly summary alongside a separate daily plan, or switch between the two views rather than trying to make one grid communicate both levels equally well.
Make the template easier to use
Formatting should make dates and task ownership easy to read without overpowering the schedule. Freeze the identifying columns or header rows when a large grid scrolls beyond the screen. In Excel for Windows, use View > Freeze Panes; select the cell below and to the right of the rows and columns you want to keep visible before choosing the command. For example, selecting F5 before freezing keeps rows 1 through 4 and columns A through E in view as you scroll.
Other useful refinements include:
- Use a clear date format such as d-mmm for headers, and include the year somewhere visible when the plan crosses into another year.
- Apply filters to the task list so you can review one owner or workstream at a time.
- Use a different, clearly labeled color for a milestone or status only if readers can distinguish it from the scheduled-date bars.
- Add a notes or dependency column when a task cannot begin until another task is complete.
- Keep a small legend near the grid if multiple colors carry different meanings.
Consider protecting formula cells after the layout is settled, while leaving task input cells editable. Protection can reduce accidental edits, but it is not a substitute for access controls or a backup. Before sharing a schedule, check that date formats, print layout, and any hidden columns make sense to people who did not build it.
Common problems and how to fix them
Bars that do not appear usually point to a mismatch between the dates and the rule. Check that the dates are real Excel dates, not text pasted from another source; confirm that start dates are not later than finish dates; and verify the conditional-formatting Applies to range includes the task grid. If the rule was created while a different cell was active, its relative references may be anchored to the wrong row or column.
Another frequent issue is whether finish dates are inclusive. The duration formula above counts both the start and finish date. A task from Monday to Wednesday therefore lasts three calendar days in this simple model. If your organization defines a finish date as the first day a task is no longer active, you would need a different convention and matching formulas. State the convention in the worksheet so collaborators do not interpret the bars differently.
Weekends are included in the example because the timeline has seven dates. To show business days only, create headers for weekdays rather than seven consecutive dates, and make sure each header still contains the actual date. Do not simply remove weekend columns and assume a task’s calendar duration has become its working duration. Holidays, part-time schedules, and business-day calculations require additional rules and should be modeled explicitly if they affect commitments.
If changing one task unexpectedly changes other bars, inspect the conditional-formatting rule order and its Applies to range in Home > Conditional Formatting > Manage Rules. Multiple rules can coexist, and a rule that stops other rules from applying may affect the result. A simpler template with one bar rule is easier to troubleshoot than a grid with many overlapping colors.
Template versus other scheduling tools
A worksheet template works well for a small project, a short planning horizon, or a schedule that people need to edit directly. It is flexible, inexpensive if Excel is already available, and easy to tailor. Excel templates can also be explored through File > New, although the available gallery depends on the account and installation. Search results and third-party downloads can vary, so inspect an unfamiliar file before relying on it, especially if it contains macros or external links.
Excel is less suitable when many contributors need simultaneous updates, tasks have complex dependencies, or automatic resource leveling and notifications are essential. A dedicated project-management application may provide those features more directly. Conversely, moving to a specialized tool can add setup, training, and subscription costs. Choose based on the complexity and collaboration needs of the work, not just on how polished a sample chart looks.
A Gantt chart is also not the same as a calendar. A calendar emphasizes appointments on dates, while a Gantt chart emphasizes task duration and overlap. Nor does a weekly Gantt chart automatically calculate a critical path. It shows the dates supplied to it; dependency logic and schedule-risk analysis need to be added separately or handled by a planning tool designed for them.
Frequently Asked Questions
Does Excel have a built-in weekly Gantt chart template?
Excel’s File > New gallery may offer project-planning templates, but what appears can vary. You can build the weekly layout directly with date cells and conditional formatting, which makes the schedule’s rules visible and editable.
How do I make a Gantt chart for one week in Excel?
Put seven consecutive dates in the timeline header, list each task’s start and finish dates, then apply a conditional-formatting rule that colors dates between those endpoints. The example above uses Monday through Sunday and shades each task’s active days.
Can I make each column represent a week instead of a day?
Yes. Put each week’s Monday date in the header and use the overlap rule =AND(F$4<=$D5,F$4+6>=$C5) for a grid beginning at F5. Each shaded cell then means the task overlaps that week, not that it lasts the entire week.
Why are my Gantt bars shifted or missing?
Check that the date cells contain valid dates, that the rule references the correct header and task rows, and that the Applies to range starts at the same cell assumed by the formula. Also check whether the task start date is after its finish date.
Can Excel show weekends or holidays differently?
Yes. You can format weekend header columns separately or add additional rules for dates listed as holidays. The basic bar rule does not automatically know your work calendar, so define those dates and the intended meaning of a task day before using the chart to estimate working time.
Related
- Excel Transpose Shortcut: Flip Rows and Columns Fast
- Transpose Key in Excel: Shortcut and Other Methods
- Tracking Sales in Excel: A Step-by-Step Tutorial
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Add a Pareto Line to an Excel Bar ChartYes. In Excel for Microsoft 365 on Windows, add a cumulative-percentage column beside your category counts, then use…
- Extend a Trendline to the Y-Axis in ExcelTo extend a trendline to the y-axis in Excel, select the trendline, open Format Trendline, and increase Forecast…
- Excel Pivot Table Repeat Row Labels: How to Do It EasilyTo repeat row labels in an Excel PivotTable, select the PivotTable, choose PivotTable Design > Report Layout >…
- Waterfall Chart in Excel: Setup and TroubleshootingTo set up a waterfall chart in Excel for Microsoft 365 on Windows, put each step and its…
- How to Make a Pivot Table in Excel From Your Own DataTo make a PivotTable in Excel for Microsoft 365 on Windows, put your data in a clean table…
- Excel Pivot Table: Hide Columns Without Losing DataIn Excel for Microsoft 365 on Windows, select the worksheet column letter above the PivotTable and choose Home…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.