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
