Excel Gantt Chart by Week: Build a Weekly Timeline

To make an Excel Gantt chart by week, list each task’s start and finish dates, put consecutive Monday dates across the timeline, then use conditional formatting to fill a week’s cell whenever that week overlaps the task. In Excel for Microsoft 365 on Windows, select the timeline grid and choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format.

What a weekly Gantt chart shows

A Gantt chart places tasks in rows and time periods in columns. Filled cells show when work is scheduled, so you can scan the project’s sequence and overlap without reading every date. A weekly version uses one column per week rather than one per day. It is useful for project plans spanning several weeks or months, where a daily grid would be wide and crowded.

Excel does not have a dedicated weekly Gantt chart button. The familiar result is usually a formatted worksheet grid: task details sit on the left, week dates run along the top, and conditional formatting colors the cells that belong to each task’s date range. This approach is easy to adjust and keeps dates and task information visible together. It is not the same as a chart object with a horizontal date axis, though a stacked bar chart is another possible method.

A weekly view is intentionally less precise than a daily one. A task lasting one day and a task lasting all week may both mark the same weekly cell. Use the view to communicate a broad schedule; keep the actual start and finish dates in the task table when exact timing matters.

Set up the task table and weekly timeline

Start with a simple table. Put headings in row 1, tasks in rows 2 onward, and use these columns:

A: Task name
B: Start date
C: Finish date
D: Owner or team, if useful
E onward: One column for each week

Enter real Excel dates in columns B and C, not text that merely looks like a date. For example, a task called “Draft outline” might start on January 7, 2026, and finish on January 9, 2026. Another task could run from January 12 through January 23. The weekly columns can show the Monday that begins each week; a Monday-to-Sunday week then occupies one column.

To calculate the Monday of the week containing the earliest start date, with start dates in B2:B20, enter this in E1: =MIN($B$2:$B$20)-WEEKDAY(MIN($B$2:$B$20),2)+1. With the earliest start date January 7, 2026, the formula returns January 5, 2026, the Monday of that week. Format E1 as a date using Home > Number Format, then fill later timeline cells with a seven-day increment. With the first week date in E1, enter in F1: =E1+7. It returns January 12, 2026, and filling the formula right continues the weekly dates. If you prefer, type the first Monday yourself and use the same increment formula.

Make enough week columns to cover the latest finish date. If the project ends in April, do not stop the timeline in March; otherwise, late tasks will have dates in the task table but no visible bars. You can leave a small margin of one or two extra weeks for schedule changes.

Apply conditional formatting to draw the bars

Select the area where the bars should appear, such as E2:AZ20. Choose Home > Conditional Formatting > New Rule, then select “Use a formula to determine which cells to format.” With the week-start dates in row 1, task start dates in column B, task finish dates in column C, and the selected range beginning at E2, use: =AND(E$1<=$C2,E$1+6>=$B2). Click Format, choose a fill color, and confirm the rule. The formula checks whether the week’s Monday is on or before the task finish date and whether the week’s Sunday is on or after the task start date. If both are true, the week and task overlap, so Excel colors that cell.

The dollar signs are important. In E$1, the row stays fixed as the rule moves down the task list, while the column can change across the weekly timeline. In $C2 and $B2, the date columns stay fixed while the row changes for each task. If your timeline begins in a different cell, adjust the references to match the top-left cell of the selected range.

The overlap test marks any week that contains at least one day of a task. For example, a task from Friday, January 9, to Tuesday, January 13, will color both the week beginning January 5 and the week beginning January 12. That is expected: the task crosses the boundary between two Monday-to-Sunday weeks. A task beginning and ending on the same date still marks its week.

Format the worksheet so the schedule is easy to read

Use a consistent, restrained format so the bars stand out from the dates and task labels. A few practical adjustments help:

Format the timeline headings as dates, for example with a display such as “5 Jan.” The underlying values remain dates, so formulas continue to work.
Make the timeline columns narrow and similarly sized. Widen columns A and D enough to read task names and owners.
Use one fill color for ordinary work and reserve a contrasting color for milestones, deadlines, or a chosen status.
Bold the heading row and consider a border below it to distinguish the dates from the schedule.
Use View > Freeze Panes to keep task names and headings visible while scrolling a wide timeline. Select the cell below and to the right of the rows and columns you want frozen before choosing the command.

For a clearer date label, you can add a row above the dates that identifies the period as “Week starting,” or use a heading such as “Week of 5 Jan.” Avoid labeling the columns only with week numbers unless the year is also clear: week numbers repeat annually, and different teams may follow different week-number conventions. Showing the Monday date makes the timeline easier to interpret.

Choose a week convention and suitable level of detail

Decide what “by week” means before building the timeline. A Monday-to-Sunday week is common for planning, but some organizations use Sunday as the first day, while shift-based or retail schedules may use a different boundary. The conditional-formatting formula above assumes Monday starts the week and that the six days after it complete the period. If your weeks begin on Sunday, use Sunday dates as the headers and compare each header through the following six days instead.

Calendar weeks are not the only useful grouping. A project team may prefer seven-day periods counted from a project launch date, or a workweek view that focuses on weekdays. The dates in the header should match the period described by the chart. A Monday-to-Sunday cell still represents the entire calendar week even if the team does not work weekends; the bar indicates scheduled overlap, not necessarily hours worked on every day.

Weekly columns suit planning where a day-level distinction is not essential. For a short project, a daily view can show handoffs and exact deadlines more clearly. For a long roadmap, monthly columns may be easier to scan. A useful rule is to select the finest time unit that readers can realistically act on without making the sheet unwieldy.

Keep the chart maintainable as dates change

The color bars respond to changes in start dates, finish dates, or week headings because they are based on formulas. They do not automatically create more timeline columns when a project is extended, however. Add or fill more weekly columns if the new finish date falls outside the displayed range, and ensure the conditional formatting rule covers the added cells. To review the rule, select a formatted cell and choose Home > Conditional Formatting > Manage Rules.

For a larger plan, turn the task list into an Excel table using Insert > Table. Tables make it easier to add and filter task rows, although the weekly timeline beside the table still needs enough columns and an appropriate conditional-formatting range. Keep task names concise, and consider filtering by owner or phase when the plan becomes too dense. A Gantt view can show sequence and overlap, but it is not a substitute for a task register that records dependencies, status, or notes.

Protect the meaning of the dates by checking them when entering new tasks. A finish date earlier than its start date will not describe a normal task period and can produce a confusing display. Similarly, a blank date is not a planning decision. You may want to flag incomplete rows separately rather than treating missing dates as a scheduled task.

Common problems and how to fix them

No cells are colored: Check that the conditional-formatting formula starts with the correct top-left timeline cell, such as E2, and that the rule applies to the intended grid. Confirm that B, C, and the week headings contain actual dates.
The bars are shifted by a week: Check that each heading is the intended first day of its week and that the formula’s timeline reference points to the heading row. A Monday-based rule paired with Sunday headings will give misleading results.
A task appears in two columns: This is normal when its date range crosses a weekly boundary. The rule marks every week that overlaps at least one task day.
Dates display as numbers: Excel stores dates as serial values. Apply a date format to the heading cells rather than changing the formula.
Bars stop before the project ends: Extend the timeline and the conditional-formatting range far enough to include the later dates.
Only some rows work: Open Manage Rules and check the “Applies to” range. Also check that the row references in the formula are relative, as in $B2 and $C2, rather than locked to one task row.

Weekly grid or stacked bar chart?

A conditional-formatting grid is usually the simplest choice when people need to edit task dates, read task names, and scan weekly overlap in one place. It is easy to customize and does not require inserting a separate chart object. Its limitation is that it represents time in fixed-width cells: it cannot show that one task lasts two days and another lasts six days within the same week.

A stacked bar chart can represent durations along a continuous date axis and may be a better fit for presentations or daily-level schedules. It takes more setup: a typical version uses an invisible starting-date series and a visible duration series, and its axis and labels may need adjustment. A dedicated project-planning tool may be more suitable when the schedule needs dependency links, automatic rescheduling, workload views, or collaboration features. Choose based on what the audience needs to do with the plan, not only how the chart looks.

Frequently Asked Questions

Can Excel make a Gantt chart by week?
Yes. Create task rows and weekly date columns, then use conditional formatting to fill cells for weeks that overlap each task’s start and finish dates. Excel provides the grid and formatting tools, rather than a dedicated weekly Gantt chart command.

Should a weekly Gantt chart start on Monday or Sunday?
Use the convention your readers expect, and label the date headings clearly. The example in this guide uses Monday-to-Sunday weeks. If you use Sunday-start weeks, set the headings and overlap test to match that convention.

Why does one task color two weeks?
If the task starts in one week and finishes in the next, both weekly periods overlap its date range. The chart is showing that the task spans a boundary, not duplicating the task.

Can I show exact task duration in a weekly chart?
You can keep exact start and finish dates in the task table, but a weekly cell does not show the number of days within that week. Use a daily timeline or a duration-based bar chart when day-level duration needs to be visible.

Will the weekly bars update when I change a date?
Yes, the conditional formatting recalculates when task dates or week headings change. You may still need to extend the timeline and the rule’s “Applies to” range if the project moves beyond the weeks currently displayed.

Excel on Mac and the web

The conditional-formatting method is also available in Excel for Mac, though ribbon layout and dialog wording can vary by release. Select the grid and look under Home > Conditional Formatting for the option to create a formula-based rule. On Mac, Command+1 opens Format Cells; on Windows, Ctrl+1 does. Excel for the web also supports conditional formatting, but some formatting controls and rule-management options may be arranged differently from the Windows desktop app. If a specific command is not visible, check the app’s current ribbon rather than assuming the workbook’s dates or formulas need a different approach.

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.