How to Create a Dynamic Monthly Calendar in Google Sheets - Template Provided

In this video, I demonstrate how to create a dynamic monthly calendar which updates depending on the month/year entered as the title.

Hopefully this will be useful for others. It's my first attempt at a video for public consumption, so I haven't tried to do any fancy editing or anything.

As is often the case with Google Sheets and other spreadsheets, there might be different/better ways to do a lot of the things I did, in retrospect; the way I accomplished the task at hand just happened to be the approach I took at the time. For example, any use of =IF(ABS(cell)>0,true,false) could nicely be replaced with =IF(ISNUMBER(cell),true,false) which would've made more sense.

[CalgaryBen]

It provides samples of all these scenarios. Please do not request edit access to the sample/template doc as I will not provide it; you simply need to follow the provided instructions to make a copy of your own, which you can edit and customize to your heart's content! Thanks.

[shannonvillines]

Just wanted to thank you for helping me turn a 2 hour process into a 10 minute process. I will be following and spreading the word to future subscribers! Thanks a bunch!!

[aurelieroque]

4 years later, and this was SUCH A HELP. I cannot thank you enough.

[elisabethfesler]

Thank you for making this template available. You made my life a lot easier. You Canadians really are the nicest people ever.

[DrLazerbeam]

I never thought I'd be watching Excel tutorials recreationally but this was really useful for me and I'm really grateful. Thanks a lot

[kcron]

I would love a video tutorial on how you set up the Linked to Event List calendar in your spreadsheet. Thank you for making this! Very generous and you saved me months of time :)

[kelliephillips]

Very helpful, even in 2023. Thank you so much for sharing this. I followed the tutorial because I wanted to see if I could do it my self. I changed the colors and and sizes of the borders. I messed up towards the end with the shading, and it saved and had to start over, but it wasn't too bad. Thanks again. :)

[qduopql]

Thank you so much, Ben! I create a wall calendar every year for my school and have always used MS Publisher. They've just switched me to a Mac and won't purchase a license for MS Publisher so I've been looking for an alternative. Your tutorial is perfect and I really appreciate you including the link to the actual google sheet. I've made a copy and am well on my way to creating our 2024-2025 calendar!

[soniarao]

Hi Ben - Thank you so much for the amazing explanation and walking us all through this so clearly. Also, thank you for putting together the google spreadsheet that is ready to go. I'm a homeschooling mom, I came here to set up a calendar on google but now I'm so excited to learn more about using sheets! Thank you!

[GTAHomeGuy]

I haven't cracked into what the calendar you have provided yet but I want to say you are AMAZING for saying "bypass and link in description"! As well as explaining how to copy on the sheet. I needed something quick and you didn't make us wade through a tutorial if we just needed a quick fix. You really gave value glad I found your vid, thank you and all the best in 2020!

[mikeramarao]

Love the tutorial. So crisp and clear! This is the kind of teaching that people need for learning more!
Thank you!

[AdrienneWalton-ckei]

This was very helpful--I'm using the link provided right now but plan to use your very detailed instructions to create an academic calendar, including national holidays and with a section for notes on the right side. Thanks so much for this!!!

[oyewunmioyetola]

Woow I am impressed, It was so crystal clear, in fact I am so excited after watching the steps and creating my calendar. I am feeling like a PRO right now

[sambrunt]

Listening to your dulcet tones while following your instructions was very soothing. I must have made an error or possibly because I didn't change my date format to the USA, so my efforts didn't pay off - but you provided all the work for me to copy anyway, so all round a very successful outcome. Thank you very much @CalgaryBen, you are awesome

[dwdanceStudio]

Hello Mr. Ben, I just wanted to say, that your video has educated me, a little more. Have a great day! - Hans

[tmrfoushee]

Thank you, Ben! Your sharing has saved me so much time on behalf of my nonprofit all-volunteer group. I can migrate group's current speaker calendar from xl to Sheets and easily offer links with anyone interested..., one of the members who was up in middle of night wondering if we had a speaker lined up. THNAK YOU!

[meganmotta]

thank you so so much!! perfect step-by-step explanation, I was able to follow all the way through clearly:)

[mariaeduardasanto]

Thank youuu! You just saved me! U dont have idea, spend many hours looking for a sheet like this!

[kendrahoffman]

Thank you much. The link to make a copy of the calendar was perfect. I am a teacher and this will make my like so much easier.

[biblicalresourceswithgwend]

Thanks Ben this is awesome I really appreciate you taking the time to go slow with your instructions which gave me the opportunity to follow along thanks a bunch