Yearly Planner Summary: Events per Month with COUNTIFS & a Stacked Column Chart
This lesson is part of the course
In this lesson
You summarise Northgate's 2026 event log by month and type, find the busiest month and the months without an audit, and chart the year.
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