Excel Forum



Excel Magic Trick 327: Gantt Chart with Weekends and Holidays


See how to create a Gantt Chart that will include highlight the workdays one color and weekends and holidays another color. See the WORKDAY function to calculate the end date, and the OR, AND, and WEEKDAY functions to create the Conditional Formatting for the Gantt Cell Chart.





Got a Question? Ask it Here in the Forum.