A Daily Gantt with Progress: WORKDAY End Dates & Two Formula Rules
This lesson is part of the course
In this lesson
You build a working-day Gantt for Northgate's racking upgrade: end dates with WORKDAY, a bar for every task, a darker part for the work already done and the project's overall % complete.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- A Dynamic Monthly Calendar: First Monday with WEEKDAY & a SEQUENCE Grid Locked
- Highlighting Weekends, Closed Days & the As-of Date with Formula Rules Locked
- Week Numbers & Working Days: ISOWEEKNUM, NETWORKDAYS & WORKDAY with a Closed-Day List Locked
- A 4-on-4-off Shift Rota: Repeating Patterns with MOD & INDEX Locked
- Weekly Hours & Overtime from a Shift Rota: COUNTIF per Shift Code & MAX(0, …) Locked
- A Daily Gantt with Progress: WORKDAY End Dates & Two Formula Rules Locked
- Milestones: Days Remaining, Overdue / Due Soon Status & the Next Milestone Locked
- Yearly Planner Summary: Events per Month with COUNTIFS & a Stacked Column Chart Locked