Home » Posts

Gantt chart with weekends

To build a Gantt chart with weekends shaded, you can use Conditional Formatting with a formula based on the weekday function.In the example shown, the formula applied the calendar, starting at D4, is: =WEEKDAY(D$4,2)>5 Note: this formula deals with weekend shading only. To see how to build the date bars with conditional formatting, see this article.

April 14, 2025 · 1 min · 47 words · Gregory Rodriguez

With a hardcoded date in D4, it’s possible for you to use =D4+1 to populate the calendar.

By default, WEEKDAY returns 1 for Sunday and 7 for Saturday, but this is configurable.

you might use the WEEKDAY function inside other formulas to check the day of week.

Excel formula: Gantt chart

Excel formula: Gantt chart by week

Excel formula: Highlight dates that are weekends

Excel formula: Dynamic calendar grid

Excel WEEKDAY function