Excel Gantt Chart Template Weekly: Build a Timeline

Yes—a weekly Gantt chart template in Excel can show each task as a bar across a calendar, with one column per week. Set up a task list with start and finish dates, put Monday-start dates across the timeline, and use conditional formatting to shade the weeks that overlap each task.

What a weekly Gantt chart shows

A Gantt chart is a schedule that places tasks down the left side and time across the top. A filled bar indicates when each task is planned to happen. In a weekly version, each timeline column represents seven days rather than one day. That makes it easier to see the shape of a multiweek project without creating a very wide sheet.

Excel does not require a special chart object for this layout. A practical template is an ordinary worksheet: task details occupy the first columns, weekly dates run across the remaining columns, and conditional formatting colors cells where a task is active. This grid approach is straightforward to edit and can be printed or shared as a workbook.

A weekly view is useful for project plans, event preparation, editorial calendars, and work schedules where the exact day is less important than the week. It is not a replacement for a daily schedule when handoffs, deadlines, or work shifts depend on specific dates. A weekly bar can only communicate that some part of the task falls in that week.

Set up the template’s columns and dates

Start with a blank worksheet in Excel for Microsoft 365 on Windows. Use a layout like this, with the headers in row 4 and the first task in row 5:

Column A: Task
Column B: Owner or team
Column C: Start date
Column D: Finish date
Column E: Duration in calendar days
Columns F onward: weekly timeline

Enter real Excel dates in columns C and D, not text that merely looks like a date. Pick the first Monday you want the timeline to show and enter it in F4. For example, if the first week begins June 1, 2026, enter that date in F4. In G4, enter this formula, assuming F4 contains the first Monday and each later weekly heading should be seven days after the previous one: =F4+7. Copy G4 to the right to create the remaining week starts. Format the headings as dates, such as 1-Jun, so they remain understandable without taking up much space.

If the project starts midweek, decide whether the first displayed column should be the Monday of that week or the first project date. Monday starts make columns consistent and easier to compare; the bar will show that the task overlaps the partial first week. Keep the same convention across the whole workbook.

Calculate task duration

Duration is optional for the visual bars, but it helps readers check a plan and filter or sort tasks. With the task’s start date in C5 and finish date in D5, enter this in E5 and copy it down: =D5-C5+1. The formula counts both the start and finish dates. For a task starting June 3, 2026 and finishing June 14, 2026, the result is 12 calendar days: 14 minus 3, plus 1.

This is calendar duration, so weekends count. That is often suitable for a high-level project plan, but it is not the same as the number of working days. If a task’s finish date is earlier than its start date, the result will be negative; correct the dates rather than treating that value as a meaningful duration. You can leave duration blank if your template only needs to show the schedule visually.

Create the weekly Gantt bars with conditional formatting

Select the timeline cells for your task rows, such as F5:AZ24. On Windows, choose Home > Conditional Formatting > New Rule, then select Use a formula to determine which cells to format. Assuming row 4 contains the Monday date for each week, columns C and D contain each task’s start and finish dates, and the selected range begins at F5, use this formula:

=AND($C5<>"",$D5<>"",F$4<=$D5,F$4+6>=$C5)

Choose a fill color in the formatting dialog and confirm the rule. The formula checks whether the week—from its Monday in row 4 through six days later—overlaps the task’s dates. The dollar signs keep the date columns fixed while the row number changes for each task; the week column changes as the rule moves across the timeline. In the example above, a June 3–14 task shades the columns for the weeks beginning June 1 and June 8.

Dates are treated inclusively: a task finishing on Sunday still overlaps the week ending that Sunday. A task starting on the following Monday belongs in the next week, not the previous one. If you adjust the displayed week headings or move the task dates to different columns, revise the conditional-formatting formula and its Applies to range to match.

Make the schedule easier to read

Use visual formatting to make the worksheet usable, not merely colorful. Keep task names and dates legible, and apply a consistent bar color. You can use different colors for categories or owners, but too many colors make it harder to identify the schedule at a glance. A legend can explain any colors that convey meaning beyond “task is scheduled.”

Bold the header row and use a contrasting fill for the task-detail headings.
Adjust the width of columns A–E so task names and dates are visible.
Format the timeline headings as short dates and center them above the weekly columns.
Use borders sparingly to separate weeks or major task groups without creating a heavy grid.
Select cell F5, then choose View > Freeze Panes > Freeze Panes to keep rows above and columns to the left visible while scrolling.

That Freeze Panes choice keeps the top four rows and columns A through E on screen as you move through the timeline. If you add extra title rows above row 4, select the first timeline cell in the first task row instead, so the freeze point still sits below the headings and to the right of the task details.

Choose a useful timeline length

Plan the number of weekly columns around the project, rather than adding an unlimited number by default. A 12-week view is often compact enough for a short project; a longer initiative may need six months or a year. The number of weeks should match the planning horizon and the level of detail people can maintain. If the schedule is much longer than the screen, freeze the task details and consider grouping work into phases.

For a reusable template, keep enough blank task rows for normal use and extend the conditional-formatting range when adding more. A shorter range is easier to print; an oversized sheet may produce many mostly empty pages. Use Page Layout options such as landscape orientation and scaling if you need a printout, and check Print Preview before distributing it. Scaling a very wide schedule to one page can make dates and task names too small to read.

Weekly template versus daily Gantt chart

A weekly grid is more compact than a daily grid and works well when progress is reviewed once a week or tasks typically last several days. It also reduces the temptation to imply more precision than the project plan actually has. Its trade-off is that it cannot show the exact start day, a one-day delay, or a handoff within a week clearly. A task scheduled from Wednesday through Friday may fill the entire weekly cell, just as a task spanning all seven days does.

Choose a daily layout when the work depends on exact dates, such as a short event run sheet or a sequence of tightly coordinated tasks. Choose monthly columns for a high-level roadmap where weekly detail would be excessive. You can also keep a weekly overview and a separate detailed schedule, but designate one as the source of truth and update both deliberately to avoid conflicting dates.

Common problems and practical checks

No bars appear: Check that start and finish entries are actual dates, the formula refers to the correct date columns, and the rule’s Applies to range covers the timeline cells.
Every week is shaded: Verify that the week headings are dates, not text, and that the conditional-formatting references use F$4 for the first timeline column.
Bars are shifted: Confirm that each heading is the Monday starting that week and that the comparison uses the full week through F$4+6.
Blank tasks show bars: Keep the checks for empty start and finish cells in the rule formula. They stop incomplete rows from being treated as scheduled work.
New tasks are not colored: Extend the rule’s Applies to range to include the new rows, or create the template with enough task rows for expected use.

For a quick audit, pick one task with dates you can check by hand and trace the weeks it should overlap. Then test a task that starts and ends on the same date, and one that ends on a Sunday. This catches common boundary mistakes before the schedule is shared.

Using an existing Excel template

You can look for a starting point through File > New and search for Gantt, but available templates can vary by account, region, and connection. Preview any result before adopting it: some templates use daily dates, sample data, or a stacked bar chart rather than a weekly worksheet grid. A template that looks attractive may still need its date logic, week-start convention, and print layout changed to fit your project.

When adapting a downloaded workbook, replace sample tasks and dates carefully, then inspect conditional-formatting rules and formulas rather than assuming they follow your new range. Save a separate working copy before making substantial changes. Excel’s desktop menus on Mac are similar for entering dates and applying conditional formatting, though dialog layouts and some ribbon details can differ. Excel for the web supports many ordinary worksheet and formatting tasks, but the desktop app can be more convenient for reviewing complex rules and print settings.

Frequently Asked Questions

Does Excel have a weekly Gantt chart template?
Excel’s File > New gallery may offer Gantt-related templates, but availability and layout vary. You can also build a weekly grid with task dates and conditional formatting, as described above, without relying on a particular gallery template.

How do I make the weeks start on Monday?
Enter a Monday date in the first timeline heading, then add seven days for each heading to its right. The weekly bar rule should compare each heading with the task dates across that Monday-through-Sunday period.

Can a weekly Gantt chart show partial weeks?
It can show that a task overlaps a week, but a single weekly cell does not show how many days of that week are occupied. For exact partial-week detail, use a daily timeline or add separate start and finish dates beside the chart.

Can I track percentage complete?
Yes, but a basic conditional-formatting bar only indicates the scheduled span, not progress. Add a separate Progress column and enter a percentage for each task, then display that value as text or use a separate visual treatment. Keep progress distinct from planned dates so readers do not mistake a scheduled bar for completed work.

Why does the bar include a week when only one day overlaps?
The rule marks a week whenever any date in that week intersects the task’s start-to-finish range. That is the intended behavior for a weekly overview; the full cell represents an overlapping week, not seven days of work.

When a spreadsheet is enough

A weekly Excel Gantt template is a good fit when a small group needs a readable schedule, dates change occasionally, and the workbook’s owner can maintain it. It is less suitable when many people need simultaneous updates, dependencies must automatically reschedule later tasks, or notifications and workload planning are essential. In those situations, dedicated project-management software may provide more controls. Even then, an Excel overview can remain useful for a simple, shareable snapshot—provided its dates and update owner are clear.

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.