A Dynamic Monthly Calendar: First Monday with WEEKDAY & a SEQUENCE Grid
This lesson is part of the course
In this lesson
You build the monthly calendar Northgate's hub team prints for the notice board: type any date and the whole grid redraws for that month.
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