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: https://www.instagram.com/spreadsheet.mode
🎵 TikTok: https://www.tiktok.com/@spreadsheetmode
📌 Facebook: https://www.facebook.com/share/17RMCtGF6P/?mibextid=wwXIfr

Видео How to Create a Dynamic Calendar in Google Sheets | Sunday, Monday & Dropdown Version канала Spreadsheet Mode