A Daily Gantt with Progress: WORKDAY End Dates & Two Formula Rules
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- A Dynamic Monthly Calendar: First Monday with WEEKDAY & a SEQUENCE GridFree
- Highlighting Weekends, Closed Days & the As-of Date with Formula Rules Pro
- Week Numbers & Working Days: ISOWEEKNUM, NETWORKDAYS & WORKDAY with a Closed-Day List Pro
- A 4-on-4-off Shift Rota: Repeating Patterns with MOD & INDEX Pro
- Weekly Hours & Overtime from a Shift Rota: COUNTIF per Shift Code & MAX(0, …) Pro
- A Daily Gantt with Progress: WORKDAY End Dates & Two Formula Rules Pro
- Milestones: Days Remaining, Overdue / Due Soon Status & the Next Milestone Pro
- Yearly Planner Summary: Events per Month with COUNTIFS & a Stacked Column Chart Pro