How to Build a Dynamic Calendar in Google Sheets

In this video, I teach you how to build a dynamic calendar in Google Sheets from scratch.

What's amazing about this template is that you can select any month for any year, and the calendar will automatically update all by itself. On top of that, this calendar is perfect for printing either in landscape or portrait orientation.

Join me in building this amazing template from scratch!

TEMPLATE LINK

RESOURCES

LEARN EXCEL OR GOOGLE SHEETS
- Google Sheets Masterclass: Coming soon...

MUSIC TRACK
Track: Ikson - Still [Official]
Music provided by Ikson®

TIMESTAMPS
00:00 - Intro
01:10 - Build the Template
09:41 - Conclusion
10:17 - Outro

[KathyWoodward-jfwm]

After spending hours watching 2 other videos while trying to implement what they were saying I was about to give up. I then found your instructions and they were WONDERFUL! I am a total beginner and I was able to create a great calendar thanks to you.

[karinkott]

Crystal clear instructions. Thank you so much!!!

[elmercartoneros]

You are amazing! Easy and understandable. All your videos are informative and applicable to me. Million thanks 🙏🏻

[lenamccain]

Thank you so much for this! I've been trying to figure this out for what seems like forever. Really appreciate it!

[ibrahimbhalfas]

Your directions is so amazing very clear and definitely very helpful. Jazakallah khair brother!

[branscsmsbc]

omg... I've been looking this for weeks. You're so amazing. It was fun, so easy to follow, and you explain so well. THANK YOU SO MUCH.

[qlngxrw]

amazing! thank you very very very much for your amazing video

[jasminedawkins]

Do you have a video on how to add additional rows( add row below row 6) without it changing the date formula for each cell. Trying to add rows beneath dates for an Event space to just type events happening for the day.

[meaganlong]

This was so fun and easy to build! Your directions are so clear and easy to follow! Could you explain how the formula in cell B6 works? I feel like I'll be able to use that in future projects for sure!

[khairinakhairudin]

hi, your tutorial really help me so much, but I change the layout according to my preferences. however for conditional formatting it doesn't work, I try looking up another solution, unfortunately it didn't work. hope you can help me. thank you so much!

[arandomuser]

Amazing tutorial! Perfect for creating my own Planner, but I did encounter a problem;
When trying to follow your Conditional Format Rules bit, for some reason it will select all the tabs, like I couldn't get it to make it different (select the days that are not on the month)
Is there a way to fix it?

[rodrigocastilho]

Thanks for the video! It helped a lot.
I was wondering if it is possible to add notes to the days before printing? That'd help a lot! Cheers

[cpiva]

Hi! Thank you for the video!!
One question, how can I add the number of week to the right?

[VanitysGunn]

8:34 The formula didn't work with <> but it did with -
Ty for the clear instructions. Great tutorial.

[noeymobile]

Hi, great tutorial, but i have a problem using <> in conditional formating, it's say invalid formula...would help me out with this ?

[nyaheadley]

This is amazing thank you. I'd like to create a calendar that I could write appointments in so i need space underneath the date. Normally i would put the date numbers on alternate rows ( leaving a row in between) How would i do that without messing up your formula? Also if i wanted to be able to choose between a sunday start and a monday start? Thank you so much in advance

[lindsaywilliams]

is there anyway to make it so your calendar dates are in a seperate cell and you have a row of cells under one week for writting things in that cordinate to that date?

[jcninfm]

Is it possible to do this with empty rows in between each date? In other words, I'd like to have 1/2/24 in row 2, then 5 blank rows under it, then 1/9/24 in row 8 and so forth. The whole calendar would use 38 rows including the days of the week row.

[scroopmd]

thanks for the great tutorial. at 6:00 the datevalue function gives me an error when i enter can you please help me with that

[mdavis]

WOW, this was such a great, well-delivered and user-friendly tutorial. Thanks so much. One question. Can this be made into an events calendar, where you can add links to event information, whether that info is housed inside of Google drive (i.e. Google Docs, Google Sheets, Google Forms, etc.) or external internet links? Looking to build something like this. Thanks again.🙂