Excel Gantt Chart: Exclude Weekends in Your Schedule

Yes. To make an Excel Gantt chart exclude weekends, build its timeline from working dates rather than consecutive calendar dates; for a worksheet-based Gantt, use WORKDAY to generate weekday headings and conditional formatting to draw each task bar. A standard date-based chart does not automatically remove Saturdays and Sundays, so the method matters.

What excluding weekends means

A Gantt chart places tasks against a timeline. In a simple Excel version, each column might represent one date, and colored cells show when tasks are scheduled. If every calendar date gets a column, Saturday and Sunday remain part of the timeline, even if no work is planned on those days. That can make a five-workday task look as though it takes seven days from start to finish.

There are two different ways to handle this. You can leave weekends visible but keep task durations in working days, or remove weekends from the displayed timeline so the next column after Friday is Monday. The first approach is useful when people need to see calendar dates and understand elapsed time. The second makes a compact schedule focused on workdays. Neither is universally better: choose based on whether the reader needs to see nonworking dates.

Excel does not have a single Gantt chart command with an exclude-weekends switch. Most Excel Gantt charts are created either with a date grid and conditional formatting or with a stacked bar chart. Those approaches handle time differently, which explains why a chart can still show weekend gaps even when task durations use working days.

Build a timeline containing only workdays

For a straightforward worksheet Gantt, put the project start date in B1. Set up a task table with task names in A5:A20, start dates in B5:B20, and durations in working days in C5:C20. Use row 4 for the timeline, starting in D4. Make sure task start dates fall on working days; a task scheduled to begin on a weekend needs a deliberate adjustment rather than an unexplained blank in the chart.

With the project start date in B1, enter this in D4 to show the first working date on or after the project start:

=WORKDAY($B$1-1,1)

With the first workday in D4, enter this in E4 and fill right to create the remaining weekday headings:

=WORKDAY(D4,1)

WORKDAY advances by working days and, by default, treats Saturday and Sunday as weekends. The first formula also works when B1 is already a weekday: subtracting one day and advancing one workday returns the project start date. If B1 is Saturday or Sunday, it returns the next Monday. Format the headings as dates, such as d-mmm, so a compact row remains readable. The cells still contain real date values, so date comparisons in later formulas work normally.

To make weekend columns visible instead, fill the headings with consecutive calendar dates. That is a different design, not an error: it preserves the calendar, while the workday-only version compresses nonworking days out of the display.

Draw task bars with conditional formatting

Once the headings list working dates, Excel can color the cells between each task’s start and finish. Select the schedule area, such as D5:AZ20, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. With dates in D4:AZ4, start dates in column B, and working-day durations in column C, use:

=AND(D$4>=$B5,D$4<WORKDAY($B5,$C5))

Choose a fill color for the rule and confirm it. The dollar signs keep the date-heading row and task data columns in the correct places as Excel evaluates the rule across the selected grid. In this formula, the finish boundary is exclusive: a one-workday task starting Monday colors Monday, not Tuesday. A five-workday task starting Monday colors Monday through Friday.

The duration in column C must mean working days for this method. If a task starts on a weekday and takes three working days, enter 3; the bar will cover its start date and the next two workdays. If the task must start on Monday but its start field contains Saturday, adjust the task date first or the bar may not begin on any displayed heading. It is better to correct the schedule data than to disguise the mismatch with extra formatting rules.

Conditional formatting is often the simplest option for a practical project plan. You can add columns for owner, status, or notes without changing the date logic, and the colored cells update when dates or durations change. It is also easy to make the timeline longer: fill the date headings and extend the conditional formatting range to cover the added columns.

Account for holidays and different workweeks

Excluding Saturday and Sunday is not the same as excluding every nonworking day. A public holiday or company shutdown may also need to disappear from the timeline and be excluded from task duration calculations. List holiday dates in a range such as J2:J20, using actual Excel dates rather than text that only looks like a date.

With the project start date in B1 and holidays in J2:J20, use this in D4 for the first workday on or after the project start:

=WORKDAY($B$1-1,1,$J$2:$J$20)

With the first workday in D4 and the same holiday list in J2:J20, use this in E4 and fill right:

=WORKDAY(D4,1,$J$2:$J$20)

The date headings will skip listed holidays as well as the default weekend. The conditional-formatting rule should also use the holiday list when it calculates the date after the task’s final workday. With the same task layout as above, change it to:

=AND(D$4>=$B5,D$4<WORKDAY($B5,$C5,$J$2:$J$20))

For a work pattern other than Saturday and Sunday, Excel provides WORKDAY.INTL. It lets you specify a weekend pattern; for example, the weekend code 7 represents Friday and Saturday. A seven-character weekend string can also mark nonworking days from Monday through Sunday, where 1 means nonworking and 0 means working. Use the same weekend definition consistently for the timeline and task-bar calculations, or the dates may not line up.

How stacked bar Gantt charts differ

A stacked bar chart is another common Excel Gantt design. It normally uses a hidden series for the gap before each task and a visible series for the task duration. This can look polished and is convenient when you want a chart object, but a date axis is continuous: it represents calendar time, so Saturdays and Sundays do not disappear just because a duration was calculated with working days.

One workaround is to position tasks using working-day offsets instead of calendar dates. With the project’s first workday in B1, task start dates in B5:B20, and holiday dates in J2:J20, a helper value for a task’s offset can be calculated as:

=NETWORKDAYS($B$1,B5,$J$2:$J$20)-1

This assumes both dates are working days and the task starts on or after the project start. The result counts working days from the project start through the task start, then subtracts one so the first workday has offset zero. In a stacked bar chart, use that offset as the invisible first series and the task’s working-day duration as the visible series. The horizontal scale then represents working-day positions rather than calendar dates.

The trade-off is that the chart’s numeric axis is no longer a normal date axis. Adding attractive date labels can take additional setup, and a chart organized this way may be less intuitive to maintain than a date-grid Gantt. If exact calendar dates are central to the audience, keep the date axis and show weekends; if a compressed workday sequence is central, use a workday grid or working-day offsets.

Choose the right layout for the schedule

Before building the sheet, decide what the timeline needs to communicate. A weekly project overview may not need one column per day at all, while a team coordinating handoffs may need a clear daily schedule. The best choice depends on the number of tasks, the level of detail, and whether nonworking time matters to the people reading it.

Use a workday-only grid when readers want to compare task sequences and working-day durations without weekend gaps.
Use a full calendar grid when readers need to see actual dates, weekend work, elapsed time, or deadlines that fall on nonworking days.
Use a stacked bar chart when a chart object is important for a presentation, and decide explicitly whether its axis represents calendar days or working-day offsets.
Include holidays when the schedule crosses public holidays, planned closures, or other dates when the team does not work.

A schedule that skips weekends should not imply that a Friday-to-Monday handoff takes one calendar day. It takes one working-day step in the compressed display, but three days elapse on the calendar. If elapsed time, service-level commitments, or weekend coverage matter, add context such as a separate calendar finish date or a visible note explaining the compressed timeline.

Common problems and checks

If bars appear one day too long or too short, check whether the duration is inclusive. The conditional-formatting example treats the start date as day one and uses an exclusive finish boundary, so a duration of five covers five workdays. Also verify that the value in the duration column is a number, not text, and that each start date matches a displayed workday.

If the chart skips weekends but includes a holiday, confirm that the holiday cell contains a true date and that the holiday range is included in both the heading formulas and the bar rule. If headings skip a holiday but bars do not, the two parts of the schedule are using different working-day definitions. Keep the holiday list in one maintained range rather than typing different holiday dates into multiple formulas.

If the chart shows blank columns at the end, the date headers may extend farther than the project needs. That is harmless, but you can reduce the selected formatting range or stop filling the timeline after the planned finish. Conversely, if a task bar ends at the edge, extend the timeline so its last working day has a heading. Conditional formatting does not create missing dates automatically.

Finally, distinguish a working-day duration from elapsed calendar duration. A task that needs five days of work and starts Monday may finish Friday if there are no holidays or interruptions. A task that lasts five elapsed days has a different meaning and may cross a weekend. Use labels such as Working days and Calendar finish date to prevent readers from interpreting the same number in two ways.

Frequently Asked Questions

Can Excel automatically exclude weekends from a Gantt chart?
No single built-in Gantt setting removes weekends from every Excel chart. A workday-only date grid made with WORKDAY is a common solution; a standard date-axis chart continues to represent calendar time.

Does WORKDAY exclude holidays as well as weekends?
It excludes Saturday and Sunday by default. To exclude holidays too, supply a range of holiday dates as the optional holiday argument, and use that range consistently in the date headings and task calculations.

Can I show weekends but keep task lengths in working days?
Yes. Keep consecutive calendar dates in the headings and calculate task durations using a working-day convention. This preserves the visible calendar, but the bar or its end-date logic must be designed carefully so weekends do not count as work.

Why does a five-day task sometimes finish on Monday?
It may have started on Tuesday, or a holiday may have interrupted the workweek. A five-working-day duration counts working dates, not five consecutive calendar dates. Check the start date, weekend pattern, and holiday list.

Can I use a Friday-Saturday weekend?
Yes. Use WORKDAY.INTL with a weekend code or weekend pattern for that schedule, and apply the same setting to every formula that generates dates or calculates task boundaries.

Will this work in Excel for Mac or Excel for the web?
The worksheet functions and conditional-formatting approach are available in current Excel versions on Windows, Mac, and the web, though the ribbon layout can differ. The menu path given here is for Excel for Microsoft 365 on Windows.

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.