Excel Forum
Similar Content
Add Time Together Limiting by Working Hours and Excluding Weekends and Holidays in Excel
Tutorial: Add two times together to get a future date and time that falls within working hours, excl...
Create Gantt Chart in Excel Easily
Tutorial: Easy step-by-step guide to creating a Gantt Chart in Excel. Following these steps, it sh...
Create a Column Chart with a Macro in Excel
Macro: This macro adds a column chart to Excel. This is an easy to use macro that allows you to q...



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.