Create a Gantt Chart in Google Sheets - Part 2: Work Days

This is part two of the How to Create a Gantt Chart in Google Sheets series for project managers and picks up immediately where the first video left off. You can watch part one here: https://youtu.be/8eKk0M2zGIk?si=UdBOaNXZS9kXpjRA In this advanced tutorial, you'll learn how to: • Customize which days of the week are work or weekend days using the WORKDAY.INTL function • Create the ability to toggle showing/hiding weekends • Highlight non-working days using conditional formatting and the NETWORKDAYS.INTL function • Make your tasks exclude weekends using the WORKDAY.INTL function You can follow along step-by-step using your spreadsheet from part one, or you can get the free template (Simple Gantt Chart for Google Sheets) from the link below: https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html CONTENT 0:00 Introduction 0:29 Updating the part one spreadsheet 1:08 Adding a workdays string 1:30 Hiding weekends 1:56 Customizing weekends 2:34 Toggle show/hide weekends 3:21 Highlight weekends 4:21 Using workdays to define tasks 5:07 Final task updates 👍 Remember to Subscribe and Turn on Notifications (click on the bell) MORE GANTT CHART TEMPLATES Another free Gantt Chart for Google Sheets can be found here: https://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html MAKE A GANTT CHART IN EXCEL Watch our popular video series on how to make a gantt chart in Microsoft Excel: https://www.vertex42.com/ExcelTips/how-to-make-a-gantt-chart-in-excel.html GANTT CHART TEMPLATE PRO: A more feature-packed version for Google Sheets is available via the Pro package. It includes color-coding, more ways to define tasks and predecessors, and lets you change the timeline from daily to weekly or monthly. See the link below: https://www.vertex42.com/ExcelTemplates/gantt-chart-template-pro.html MUSIC CREDITS: Pixelate, by Zac Nelson, licensed via ArtList