How to Create a Dynamic Calendar in Google Sheets | Sunday, Monday & Dropdown Version
Learn how to create a dynamic calendar in Google Sheets with the SEQUENCE function. In this tutorial, I’ll show you 3 different calendar versions: starting from Sunday, starting from Monday, and a dynamic version with a weekday dropdown menu.
You’ll also learn how to:
✓ Hide dates from other months
✓ Highlight today automatically
✓ Use WEEKDAY, DATE, and IF functions
✓ Create a dynamic weekday switch
✓ Add conditional formatting in Google Sheets
📌 Formulas used in this tutorial:
Sunday-start calendar:
=SEQUENCE(6,7,
DATE(YEAR(B1),MONTH(B1),1)
-WEEKDAY(DATE(YEAR(B1),MONTH(B1),1))
+1)
Conditional formatting — active day:
=B3=TODAY()
Monday-start calendar:
=SEQUENCE(6,7,
DATE(YEAR(J1),MONTH(J1),1)
-WEEKDAY(DATE(YEAR(J1),MONTH(J1),1),2)
+1)
Dynamic weekdays:
=IF(A5="Monday",
{"Mon","Tue","Wed","Thu","Fri","Sat","Sun"},
{"Sun","Mon","Tue","Wed","Thu","Fri","Sat"})
Dynamic calendar:
=SEQUENCE(6,7,
DATE(YEAR(A2),MONTH(A2),1)
-WEEKDAY(DATE(YEAR(A2),MONTH(A2),1),
IF(A5="Monday",2,1))+1)
⏱️ Timestamps
00:00 - Intro
00:15 - Sunday-start calendar
02:42 - Hide dates from other months
03:14 - Highlight today’s date
03:41 - Monday-start calendar
05:11 - Dynamic calendar with weekday dropdown
🔗 My templates & socials:
🛍 My templates: https://alexaplanners.com/
📷 Instagram: / spreadsheet.mode
🎵 TikTok: / spreadsheetmode
📌 Facebook: https://www.facebook.com/share/17RMCt...