How to Create a Dynamic Mini Calendar in Google Sheets | Step-by-Step Tutorial for Beginners
In this step-by-step tutorial, I’ll show you how to build a fully dynamic mini calendar in Google Sheets, perfect for beginners! You’ll learn how to make the calendar update automatically based on the selected year and month, switch between Sunday or Monday as the start of the week, highlight today’s date using conditional formatting, and more.
By the end of this video, you’ll have a functional and customizable calendar that updates instantly with just a couple of dropdowns. Great for planners, trackers, or dashboard projects!
00:00 Introduction
00:53 Calendar layout
03:08 Dropdown list
04:07 Sunday / Monday Start
04:48 Start of formulas
06:50 Calendar day formula
08:44 Conditional formatting highlight today
09:38 Grayed-out days
11:07 Highlight selected week
13:28 Dynamic Mini Calendar uses
13:42 Conclusion
⏱️ What you’ll learn:
• How to use DATE, CHOOSE, and MATCH formulas
• Switching start day: Sunday or Monday
• Highlighting the current date with conditional formatting
• Clean formatting tips for a professional look
No coding needed, just formulas and formatting!
Let’s build it together.
👉 Don’t forget to like, comment, and subscribe for more Google Sheets tutorials, budgeting tools, and digital planning ideas!
📂 Explore my ready-to-use budget spreadsheets here: https://myproductivelifeco.com
Here is the formula used in the spreadsheet:
=DATE(E17,CHOOSE(MATCH(E18,{"January","February","March","April","May","June","July","August","September","October","November","December"},0),1,2,3,4,5,6,7,8,9,10,11,12),1)-WEEKDAY(DATE(E17,CHOOSE(MATCH(E18,{"January","February","March","April","May","June","July","August","September","October","November","December"}, 0),1,2,3,4,5,6,7,8,9,10,11,12),1),IF(B22="Monday", 2, 1))+1
Music track: Hawaii by Waesto
Source: https://freetouse.com/music
Free Vlog Music Without Copyright
#googlesheets #MiniCalendar #spreadsheettutorial #googlesheetstips #beginnerfriendly #DynamicCalendar #SpreadsheetDesign #conditionalformatting #productivitytools #digitalplanner #GoogleSheetsForBeginners #CustomCalendar #todayhighlight #spreadsheethacks #planningtools