Make a Gantt Chart in Excel - Part 2: Working with Work Days

This is the 2nd part of the How to Make a Gantt Chart series. This picks up immediately where the first video left off, so watch the other video first (    • How to Make a Gantt Chart in Excel   ). In this advanced tutorial, learn how to use the WORKDAY function to add work days and the NETWORKDAYS function in Excel to count work days. You'll also see how to customize weekends with the .INTL versions of these functions, and toggle showing/hiding weekend days using conditional formatting.

👍 Remember to Subscribe and Turn on Notifications (click on the bell)

0:24 Calculate work days between dates using the WORKDAY function
1:14 Highlight the weekends in the gantt chart using the NETWORKDAYS function
3:24 Create dependent tasks using WORKDAY
4:15 Highlight Holidays from a list using the MATCH function
5:43 Customize the Weekend days using WORKDAY.INTL and NETWORKDAYS.INTL
7:17 Hide and Show weekends using conditional formatting and a checkbox
8:47 Correction: Color Coding won't be shown until Part 4

NEXT VIDEO: Adding dynamic display options to switch between Daily/Weekly/Monthly/Quarterly
   • Make a Gantt Chart in Excel - Part 3:...  

LEARN MORE ABOUT DYNAMIC NAMED RANGES:
   • Dynamic Named Ranges in Excel  

VOTE ON IN-CELL CHECKBOXES:
https://v42.link/VoteCheckboxes

ABOUT THIS VIDEO SERIES
https://www.vertex42.com/ExcelTips/ho...

GANTT CHART TEMPLATE
To download my original gantt chart template for Excel (and Google Sheets) visit the following page:
https://www.vertex42.com/ExcelTemplat...

FOLLOW VERTEX42 HERE:
Twitter:   / vertex42  
Pinterest:   / vertex42  
Facebook:   / vertex42  
Instagram:   / vertex42  
Website: https://www.vertex42.com/

MUSIC: Pixelate, by Zac Nelson, licensed via ArtList