Tabellab
Menu
Courses Guides Pricing Log in Start free

A Dynamic Monthly Calendar: First Monday with WEEKDAY & a SEQUENCE Grid

Lesson 1 of 818 minLab

All lessons
  1. A Dynamic Monthly Calendar: First Monday with WEEKDAY & a SEQUENCE GridLab18 minFree
  2. Highlighting Weekends, Closed Days & the As-of Date with Formula RulesLab18 min Pro
  3. Week Numbers & Working Days: ISOWEEKNUM, NETWORKDAYS & WORKDAY with a Closed-Day ListLab20 min Pro
  4. A 4-on-4-off Shift Rota: Repeating Patterns with MOD & INDEXLab20 min Pro
  5. Weekly Hours & Overtime from a Shift Rota: COUNTIF per Shift Code & MAX(0, …)Lab18 min Pro
  6. A Daily Gantt with Progress: WORKDAY End Dates & Two Formula RulesLab22 min Pro
  7. Milestones: Days Remaining, Overdue / Due Soon Status & the Next MilestoneLab18 min Pro
  8. Yearly Planner Summary: Events per Month with COUNTIFS & a Stacked Column ChartLab20 min Pro

You are not signed in — the lab works, but your progress is not saved. Start free

Read first

In Excel

  • Custom number format for the grid: Ctrl+1 > Number > Custom, type d.
  • Month title above the grid: =TEXT(B2,"mmmm yyyy").
  • Week starting on Sunday instead? Use =B2-WEEKDAY(B2)+1 and put Sun as the first header.
Loading the spreadsheet…
Next lesson →