Milestones: Days Remaining, Overdue / Due Soon Status & the Next Milestone
This lesson is part of the course
In this lesson
You turn Northgate's milestone list into a status board: days left, a status word for every milestone and the next milestone that is coming up.
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