How to Remove Weekends From an Excel Gantt Chart in 7 Steps

Weekend columns can make an Excel Gantt chart look longer than the work really takes. A five-day task may stretch across nine calendar days, making deadlines harder to read and progress easier to misjudge. If you hide weekends manually, the chart can also break when dates change or new tasks are added. That creates extra maintenance every time your plan moves.

But here’s the truth: you can remove weekends reliably by giving Excel a workday-based timeline instead of a calendar-day timeline. In this guide, I’ll show you seven practical steps, explain the formulas behind them, and help you avoid common charting mistakes. By the end, your Gantt chart will show Monday through Friday in sequence, with Saturday and Sunday excluded from the visual schedule.

How to Remove Weekends From an Excel Gantt Chart in 7 Steps

The most reliable approach is to calculate workday positions with NETWORKDAYS, then use those positions for the chart’s starting offset and task duration. This keeps the schedule continuous while excluding Saturdays, Sundays, and optional holidays.

1. Organize the task schedule

Start with a simple task list. Use one row for each activity and add columns for the task name, start date, and finish date.

Assume the start date is in column B and the finish date is in column C. Keep the dates as real Excel dates rather than typed text. You can test this by changing the cell format to General and checking whether Excel displays a number.

2. Create a holiday list

Weekend removal usually means excluding Saturday and Sunday. You can also exclude company holidays by listing them in a separate range.

For example, place holiday dates in cells H2:H10. Leave the range empty if you do not need holiday exclusions. A holiday list makes your formulas easier to update than manually editing each task.

Here’s why: a holiday affects both the task length and the position of later tasks. A shared range keeps those calculations consistent.

3. Calculate the workday position of each task

Add a column called Workday Start. In the first task row, enter a formula similar to this:

=NETWORKDAYS($B$2,B2,$H$2:$H$10)

This counts working days from the overall project start date in B2 through the task’s start date. If the task begins on the first working day, the result is 1. If it starts on the fourth working day, the result is 4.

If your project start date sits in another cell, replace $B$2 with that reference. Keep the dollar signs around the project start and holiday range so the references stay fixed when you copy the formula downward.

4. Calculate each task’s working duration

Add another column called Workday Duration. Enter this formula:

=NETWORKDAYS(B2,C2,$H$2:$H$10)

This counts only Monday through Friday, while also removing dates listed in the holiday range. For example, a task running from Friday through Monday has a duration of two working days instead of four calendar days.

You might be wondering: what if the task finishes on a weekend? The formula still counts only working dates within the range. However, it is usually cleaner to set task finish dates on working days whenever possible.

5. Insert a stacked bar chart

Select the task names, Workday Start values, and Workday Duration values. Then choose Insert, select Bar Chart, and choose Stacked Bar.

Excel uses the first series as an invisible spacer. The second series becomes the visible task bar. This creates the familiar Gantt layout without requiring a calendar axis that includes weekends.

If Excel places the task names in the wrong direction, right-click the vertical axis, choose Format Axis, and enable Categories in reverse order. This places the first task at the top.

6. Hide the spacer series

Click the first series, which represents Workday Start. Open Format Data Series, choose Fill, and select No fill. Remove its border as well.

The invisible series still controls each bar’s horizontal position. It simply stops appearing as colored space, leaving only the task duration visible.

Let me explain: this is the key difference between hiding weekend columns and removing weekends from the calculation. The chart is positioned by working-day numbers, so Saturday and Sunday never receive a position.

7. Format the chart for clarity

Adjust the horizontal axis minimum and maximum so the chart begins near the first workday and ends near the final task. Set the major unit to 1 if you want each working day represented by one chart unit.

Then reduce the gap width between bars. A value between 20% and 50% often produces a readable schedule. Choose a clear color for task bars and remove unnecessary chart elements.

For date labels, add a helper row that displays working dates in sequence. You can use formulas such as =WORKDAY(previous_date,1,$H$2:$H$10) to generate the next working date. This gives you a visible Monday-to-Friday label sequence without weekend dates.

Why Standard Date Axes Show Weekends

Excel stores dates as sequential numbers. Saturday follows Friday numerically, and Sunday follows Saturday. A normal date axis therefore treats weekends as valid calendar positions, even when no work occurs.

For example, a task that starts on Friday and ends on Monday spans four calendar positions. Its actual effort may equal only two working days, but the chart still leaves space for Saturday and Sunday.

But here’s the truth: changing the number format will not remove those gaps. Formats can change how dates look, while the underlying axis still uses every calendar date.

Calendar time versus working time

Think of a standard date axis as a road with every mile marked. A workday axis removes the miles where your team does not operate, then renumbers the remaining route.

Which Excel Formulas Exclude Weekends?

Excel offers several useful functions for working-day schedules. The right choice depends on whether you need a duration, a future date, or a custom weekend pattern.

NETWORKDAYS for working-day counts

Use NETWORKDAYS when you need the number of working days between two dates.

=NETWORKDAYS(start_date,end_date,holidays)

For example:

=NETWORKDAYS(B2,C2,$H$2:$H$10)

This function excludes Saturday and Sunday by default. It also excludes any dates included in the holiday range.

WORKDAY for future working dates

Use WORKDAY when you want Excel to move forward or backward by a specific number of working days.

=WORKDAY(start_date,days,holidays)

For example:

=WORKDAY(B2,5,$H$2:$H$10)

This returns the date five working days after the start date. It is useful for generating a clean sequence of weekday labels.

NETWORKDAYS.INTL for custom weekends

Some teams work different schedules. If Friday and Saturday are weekends, use NETWORKDAYS.INTL instead.

=NETWORKDAYS.INTL(B2,C2,"0000110",$H$2:$H$10)

The weekend pattern uses seven digits, beginning with Monday. A 1 means non-working, while a 0 means working. Confirm the pattern carefully before building the chart.

How to Show Working-Day Labels on the Chart

Removing weekend positions can make the chart accurate, but the horizontal axis may show simple numbers rather than dates. You have several ways to make the timeline easier to read.

Use a helper label row

Create a row of working dates beginning with the project start date. For the next cell, use:

=WORKDAY(previous_cell,1,$H$2:$H$10)

Copy the formula across the row. Excel will create a sequence such as Monday, Tuesday, Wednesday, Thursday, Friday, Monday, Tuesday.

Format those cells as ddd mmm d if you want labels such as Mon Jan 6. This gives readers a direct connection between each chart position and its calendar date.

Use a two-row heading

For longer schedules, use one row for the week number and another for the working date. For example, the first row can show Week 1, Week 1, Week 1, Week 1, Week 1, Week 2, and the second row can show the individual dates.

This arrangement helps when the project spans several weeks. It also prevents the chart from becoming crowded with full date labels.

Keep labels outside the plotted area

Do not place lengthy dates inside every task bar. A cleaner approach is to keep labels above the chart or in a narrow timeline area beside it.

For example, use Mon 6 rather than Monday, January 6, 2025. The shorter label preserves space while still showing enough information for daily planning.

Common Mistakes When Removing Weekends

Hiding columns instead of changing calculations

Hiding worksheet columns can make a planning view look cleaner, but it does not always change how a chart calculates its positions. The chart may still reserve space for hidden dates.

Use workday indexes for the chart series instead. This changes the plotted values rather than only changing visibility.

Counting duration incorrectly

A common mistake is calculating duration with a simple subtraction formula:

=C2-B2+1

That formula counts calendar dates, including weekends. Replace it with NETWORKDAYS when the task duration should reflect working time.

Forgetting the first day

Whether a task lasts one or two days depends on whether the start date counts as a working day. NETWORKDAYS includes both endpoints when they are working days.

For instance, a task beginning and ending on Tuesday has a duration of one working day. Test a few short examples before applying the formula to a large plan.

Leaving holiday rules out

A chart can remove weekends correctly and still overstate capacity if public holidays remain included. Add holidays to one controlled range and use that range in every related formula.

This matters when a holiday falls between two tasks. The later task’s workday position must move forward consistently.

Using inconsistent start and finish conventions

Some teams record a finish date as the last day of work. Others record it as the first day after work ends. Either convention can work, but mixing them creates incorrect durations.

Choose one rule, write it near the schedule, and apply it to every task.

When a Project Platform Works Better Than a Manual Chart

Excel works well for a small schedule, a quick presentation, or a plan maintained by one person. It becomes harder to manage when several people change dates, dependencies, status, and ownership.

For example, moving one delayed task may require you to update formulas, chart ranges, labels, and dependent activities. A project platform can connect those changes to planning views and status updates.

That does not make Excel a poor choice. It simply means the best method depends on schedule complexity. Use a worksheet for a lightweight plan, then consider a dedicated workspace when the schedule becomes collaborative or highly dependent.

Project Planning Solution: ONES.com

Value Proposition

ONES.com combines project management and knowledge management in one platform, with ONES Project available as a Jira alternative. It can help teams move beyond manually maintained Gantt charts when planning requires shared ownership, workflow control, and ongoing status updates.

ONES Project and ONES Wiki are sold separately, so you can choose the product that matches your planning needs.

Core Capabilities

Manual chart maintenance → Gantt planning and project views → clearer schedule tracking

When dates change frequently, updating a hand-built chart can consume time. ONES Project provides structured project planning views that help teams track work in a central workspace.

Weekend and holiday confusion → Configurable workflows and fields → consistent planning rules

Different teams often track status, ownership, and deadlines differently. Custom workflows and fields let you reflect those operating rules without rebuilding a chart.

Hidden dependencies → Linked work and workflow relationships → earlier visibility into delays

A delayed design task can affect testing and launch preparation. Connected planning relationships make those effects easier to review than separate worksheet rows.

Repeated status checks → Automation → fewer routine updates

Teams can automate selected workflow actions and recurring transitions. That reduces manual follow-up for predictable project events.

Limited reporting in a worksheet → Built-in reporting → faster progress reviews

Built-in reporting helps you review progress, workload, and project activity without assembling separate charts for every meeting.

Plugin-heavy project setups → Native capabilities → fewer add-on dependencies

ONES Project supports Jira-compatible workflows, sprint management, custom fields, automation, and reporting natively. That can reduce the need to coordinate multiple extensions.

Restricted network requirements → On-premise, private cloud, and air-gapped deployment options → more deployment flexibility

ONES.com supports Cloud, On-Premise, Private Cloud, and Air-gapped deployments. The self-hosted versions maintain full feature parity with the cloud version.

Growing teams → Free plan for up to 30 seats → lower-barrier evaluation

Teams can evaluate the platform with up to 30 seats before deciding whether a broader rollout fits their working model.

Application Scenarios

A software team may begin with an Excel Gantt chart for a small release. As sprint work, defects, approvals, and testing become linked, ONES Project can provide a shared planning structure for the wider team.

An engineering team working in a restricted network may need project management without relying on a public cloud deployment. An on-premise or air-gapped deployment gives that team another operating option.

A project office may also use ONES Project for planning and ONES Wiki for related knowledge management. Because the products are sold separately, the team can adopt either capability independently.

Common Challenges and Practical Solutions

Challenge: Weekend space still appears

Solution: Check whether the chart uses calendar dates as its horizontal values. Replace those values with workday positions calculated by NETWORKDAYS.

Challenge: Task bars have the wrong length

Solution: Confirm that duration uses working-day counts rather than date subtraction. Test a Friday-to-Monday task and verify that it produces two working days.

Challenge: Holidays are treated as workdays

Solution: Create one holiday range and include it in every NETWORKDAYS, NETWORKDAYS.INTL, and WORKDAY formula.

Challenge: The task order appears upside down

Solution: Open the vertical axis settings and select Categories in reverse order. Excel often places the first selected row at the bottom of a bar chart.

Challenge: Labels become unreadable

Solution: Shorten labels, rotate the axis text, or use a separate working-date row. Showing abbreviated dates usually produces a cleaner result than displaying full date names.

FAQs

Can Excel automatically skip weekends in a Gantt chart?

Excel can calculate workdays automatically, but a standard date axis may still display weekend gaps. To remove those gaps, calculate workday positions with NETWORKDAYS and use those positions in a stacked bar chart. If you only need to hide weekend columns in a worksheet, filtering or hiding dates may be enough. For a true compressed timeline, change the chart calculations.

What formula removes Saturday and Sunday from a task duration?

Use NETWORKDAYS:

=NETWORKDAYS(start_date,end_date,holidays)

For example, =NETWORKDAYS(B2,C2,$H$2:$H$10) counts Monday through Friday and excludes any holiday dates listed in H2:H10. The function includes both the starting and ending dates when they are working days.

How do I exclude holidays as well as weekends?

Place each holiday date in a dedicated range, such as H2:H10. Then include that range in your workday formulas. Use =NETWORKDAYS(B2,C2,$H$2:$H$10) for durations and =WORKDAY(B2,5,$H$2:$H$10) when generating future working dates. Keep the range fixed with dollar signs when copying formulas.

Why does my stacked bar Gantt chart show blank space?

The blank space usually comes from the first series, which acts as the starting offset. That series must remain in the chart, but its fill should be set to No fill. If weekend gaps remain after hiding the series, check whether the offset still uses calendar dates instead of workday numbers.

Can I use a nonstandard weekend pattern?

Yes. Use NETWORKDAYS.INTL or WORKDAY.INTL when your team’s weekend differs from Saturday and Sunday. These functions accept a weekend code or seven-character pattern. For example, a pattern can mark Friday and Saturday as non-working. Verify the pattern carefully because each position represents a specific weekday.

Conclusion

To remove weekends from an Excel Gantt chart, calculate workday positions and durations instead of relying on calendar dates. Use NETWORKDAYS for task length, WORKDAY for working-date sequences, and a stacked bar chart for the visual timeline.

Remember the main checks: include holidays when needed, hide the spacer series, reverse the task order if necessary, and keep labels short. These steps turn a stretched calendar schedule into a clearer working-day plan.

But here’s the practical takeaway: if your chart keeps growing more complex, the problem may be the maintenance process rather than the formula. Excel is useful for focused planning, while ONES.com can provide a shared project workspace when dependencies, workflows, reporting, and collaboration become harder to manage manually.