How to Show Saturdays and Sundays in an Excel Gantt Chart in WPS Office
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.

- 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.
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.
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.
Click cell K7, or the first empty cell in the date header row of your Gantt chart worksheet.
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.
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.
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.

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. Open the Gantt chart workbook: Launch WPS Office and open the Excel workbook that contains your Gantt chart template.
- 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. 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. 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. Format weekend columns gray: Select the Saturday and Sunday columns and apply gray fill from the Home tab to visually mark non-working days.

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.




