Chart & Visualization Issues

How to Show Saturdays and Sundays in an Excel Gantt Chart in WPS Office

Olivia MillerOlivia Miller Nov 13, 2026 870 views

Question details

The user wants to keep Saturdays and Sundays visible in an Excel Gantt chart while still using working-day calculations for task schedules.

How to Show Saturdays and Sundays in an Excel Gantt Chart in WPS Office
Product
WPS Office Spreadsheets
Device & OS
not provided
Scenario
Building or updating an Excel Gantt chart template where weekend columns need to remain visible for full calendar context, but task durations must continue to use working days only.
Observed behavior
The date row currently advances in working-day increments, so weekend columns are missing or not visually distinct, and milestone icons may appear in incorrect columns.
Before you start

Open the Gantt chart workbook in WPS Office Spreadsheets and locate the date header row, the WORKDAY formulas, and any milestone icon rules before changing the date range.

Solution 1Recommended

Extend the date row with =J7+1 and format weekend columns

Use this method when you want Saturday and Sunday to remain visible in the Gantt chart without breaking the working-day schedule calculations.

The key is to separate calendar dates from working-day logic. Fill the date header with consecutive calendar days, but keep WORKDAY formulas for task durations so weekend-only columns do not affect schedule calculations.

Weekend columns should be formatted distinctly and return zero where appropriate so milestone icons do not appear on Saturdays or Sundays.

1
Select the first blank date cell

Click cell K7, or the first empty cell in the date header row of your Gantt chart worksheet.

2
Enter the consecutive date formula

Type =J7+1 in K7, press Enter, and then drag the fill handle across the date row to include all calendar days, including Saturdays and Sundays.

3
Keep WORKDAY calculations for task durations

In task duration and milestone cells, continue to use the WORKDAY function for working-day calculations, and make weekend columns return zero when appropriate to prevent milestone icons from appearing on weekend dates.

4
Apply gray fill to weekend columns

Select the Saturday and Sunday columns, go to the Home tab, and use the Fill Color control to apply a gray background so weekends remain visible but visually marked as non-working days.

Extend the date row with =J7+1 and format weekend columns
Weekends now remain visible: The date row shows all seven days, while task scheduling still uses working days and weekend columns display as gray non-working days without milestone icons.

Show Weekends in a WPS Office Gantt Chart

In WPS Office Spreadsheets, you can keep Saturday and Sunday visible in a Gantt chart by extending the date header with consecutive calendar dates while preserving WORKDAY formulas for task durations. This gives you a full seven-day calendar view without changing your working-day schedule.

  1. 1. Open the Gantt chart workbook: Launch WPS Office and open the Excel workbook that contains your Gantt chart template.
  2. 2. Locate the date header row: Click the first blank date cell in the header row after the last existing date in the chart.
  3. 3. Extend dates across the weekend: Enter =J7+1 using the previous date cell, then drag the fill handle to include Saturday and Sunday columns.
  4. 4. Keep WORKDAY formulas: Use WORKDAY formulas for task durations, and make weekend columns return zero where needed to avoid milestone markers on non-working days.
  5. 5. Format weekend columns gray: Select the Saturday and Sunday columns and apply gray fill from the Home tab to visually mark non-working days.
Keep Saturday and Sunday columns visible in Excel Gantt chart templatesPreserve WORKDAY formulas for accurate working-day task schedulingApply clear gray weekend formatting for easier project trackingFull compatibility with Microsoft Excel .xlsx workbooks
microsoft office alternative - wps office

Frequently Asked Questions

Why do weekend columns show milestone icons after I extend the date row?

The existing milestone rules can fill every date column automatically. In weekend columns, adjust the formula or conditional rule to return zero so milestone icons do not appear on Saturdays and Sundays.

How do I apply gray fill only to Saturday and Sunday columns?

Select the weekend columns in the date area, go to the Home tab in WPS Office Spreadsheets, and choose a gray color from the Fill Color button.

Can I still use WORKDAY formulas after showing weekends?

Yes. Keep the WORKDAY formulas for task duration calculations and extend only the date header with =J7+1. The chart shows all days, but task schedules still skip non-working days.

Does this method work with Microsoft Excel Gantt chart templates?

Yes. The method works in WPS Office Spreadsheets with .xlsx workbooks and is compatible with Microsoft Excel Gantt chart templates.

How do I copy the date formula across the entire row?

Click the cell containing =J7+1, then drag the fill handle across the date row to fill the following columns with consecutive calendar dates.