Тёмный

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

CalgaryBen
Подписаться 833
Просмотров 439 тыс.
50% 1

In this video, I demonstrate how to create a dynamic monthly calendar which updates depending on the month/year entered as the title.
To skip the tutorial and access a working template you can copy to your own document, use the following link (PLEASE don't ask for access edit access -- most users should have READ access and you can MAKE A COPY which you can edit -- instructions provided herein. Some domains such as verizonwireless.com may block your access, and I can't help you there as it's out of my hands):
docs.google.com/spreadsheets/...
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.

Опубликовано:

 

5 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 505   
@CalgaryBen
@CalgaryBen 2 года назад
I get so many questions about things like making Monday the first day of the week, or putting months side-by-side instead of on top or each other, or asking why a certain formula doesn't work for someone. PLEASE have a look at the sample I've provided: docs.google.com/spreadsheets/d/1RZ9RXTg44XkBBZx98eKeGWajYVgrULaz64Ws7FpaPGI 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.
@ardianifa
@ardianifa 2 года назад
thank you so much!
@shannonvillines5703
@shannonvillines5703 4 года назад
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!!
@mikeramarao
@mikeramarao 4 года назад
Love the tutorial. So crisp and clear! This is the kind of teaching that people need for learning more! Thank you!
@elisabethfesler8878
@elisabethfesler8878 3 года назад
Thank you for making this template available. You made my life a lot easier. You Canadians really are the nicest people ever.
@soniarao8700
@soniarao8700 3 года назад
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!
@aurelieroque2006
@aurelieroque2006 9 месяцев назад
4 years later, and this was SUCH A HUUUUUUUGE HELP. I cannot thank you enough.
@GTAHomeGuy
@GTAHomeGuy 4 года назад
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!
@shanaepaulino152
@shanaepaulino152 3 года назад
THANK YOU SO MUCH, BEN!!! This was IMMENSELY helpful for me. Even though it took me a long time to watch what you were doing and create one myself, it was worth it. I appreciate you taking the time to make this tutorial! :)
@DrLazerbeam
@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
@todd5963
@todd5963 4 года назад
This was super fun to do and I learned a lot! You went at a perfect pace. Thanks so much!
@kcron13
@kcron13 3 года назад
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 :)
@HeyBear
@HeyBear 4 года назад
Thank you, Ben. Exactly what I needed!
@biblicalresourceswithgwend2561
@biblicalresourceswithgwend2561 4 года назад
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
@rachelvelasquez5201
@rachelvelasquez5201 4 года назад
SUPER HELPFUL!! Specially the template from which I was able to get the formulas and adapt it to my own calendar styles. Thank you so much!!!
@kelliephillips5754
@kelliephillips5754 Год назад
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. :)
@falielballo-allo3327
@falielballo-allo3327 3 года назад
Thank you for sharing your knowledge on this. I have been trying to look for this exact calendar for me and my homeroom. Your generosity is a blessing. Thank you
@user-qd1uo1pq7l
@user-qd1uo1pq7l 7 месяцев назад
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!
@pizzabella4257
@pizzabella4257 3 года назад
The template is everything we needed! Thanks so much for this. You're the best!
@JSmithOLMC
@JSmithOLMC 4 года назад
Thank you for the easy to follow step by step guide (and the link in the description)!
@gen3703
@gen3703 3 года назад
Thank you so much! I just watched your tutorial and created a full year calendar thanks to your detailed video.
@warrenzonator
@warrenzonator 2 года назад
excellent pace and explanations! I'm going to be working to integrate forms and an email list for making and confirming appointments, and this was exactly the starting point I needed. greetings from Alberta
@ShelitaRN
@ShelitaRN 4 года назад
Wow! thank you so much, this is amazing, I'm just gonna use the template it saved me so much time! Thank you again!
@DeeKM12
@DeeKM12 3 года назад
This was fantastic. Really saved me lots of time on work projects!
@phoebedavis5526
@phoebedavis5526 Год назад
Great step by step tutorial. I actually created a calendar using this video though I ended up using the schedule generator template from someka. It's been very useful so far. Thank you for the video:)
@eyesforpurple
@eyesforpurple 4 года назад
Thank you for the detailed breakdown! I love my new calendar :)
@danielorr2186
@danielorr2186 4 года назад
This is wonderful! Thank you Ben!
@sambrunt2457
@sambrunt2457 3 года назад
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
@Julie-ni8ln
@Julie-ni8ln Год назад
Loved this! It was exactly what I needed. I had to back up and review several times, it was all pretty fairly new to me. Thank you for sharing!
@throughdarkness
@throughdarkness 4 года назад
Hi, Ben! Thank you for this, it has saved me a lot of time, as well as learning a nice tidbit of coding, again thank you!
@tmrfoushee
@tmrfoushee 3 года назад
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!
@Maigue-tm9rg
@Maigue-tm9rg 3 года назад
thank you so much for the tutorial. i've been wanting to learn this for the longest time. great work!
@ilmajabeen7982
@ilmajabeen7982 4 года назад
That was really cool. Thank you for sharing.
@AdrienneWalton-ck3ei
@AdrienneWalton-ck3ei 2 месяца назад
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!!!
@hannantechnologiesllc8553
@hannantechnologiesllc8553 4 года назад
Exactly what I was looking for. Thanks Ben!
@altheapolyam
@altheapolyam Год назад
Thank you so much for this video!! Very useful, and the fact that you share samples for if we run with any trouble is pretty awesome. Sorry it also gave you some trouble but I'm super thankful for this work you shared with us. Hope you have a nice day ^^
@adarshsharma5608
@adarshsharma5608 Год назад
Very helpful. Really appreciate the efforts you have put in to bring out this document.
@LNNordang
@LNNordang 3 года назад
Perfect, ty very much for the detailed description and link to the finished sheet.
@oyewunmioyetola7402
@oyewunmioyetola7402 Год назад
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
@elkinrios5610
@elkinrios5610 4 года назад
Thank you for doing the work for us, your the best!
@wilsarjohnson7785
@wilsarjohnson7785 4 года назад
OMG Thank you SO much! This was so valuable. :)
@kimvicuna5138
@kimvicuna5138 3 года назад
Glad that I was able to find your video! This really saves me a lot of time! More tutorials to come! Thank you & God bless.
@wilsononu2162
@wilsononu2162 3 года назад
Ben, thank you so much for this. Truly helpful. All the best.
@georgieanngetton
@georgieanngetton 3 года назад
Thank you so much for this! I have been looking for how to do this and you gave a perfect explanation
@leanneworley1496
@leanneworley1496 4 года назад
This is great - so helpful! Thank you!
@wizzywidge9039
@wizzywidge9039 4 года назад
Thanks! This was a very helpful video. Making a calendar for a group to share. Learned a lot!
@cryptonursery5027
@cryptonursery5027 3 года назад
thank you so much for sharing and teaching this. made my own as i watched and works perfectly for what i needed!
@melissaadolph8165
@melissaadolph8165 4 года назад
Thank you so much for allowing the copy of the dynamic calendar that you made!
@VChau-ki7xu
@VChau-ki7xu 4 года назад
Thank you so much Ben! You saved me so much time :)
@tiffanyhogue1186
@tiffanyhogue1186 3 года назад
Thank you! This video was easy to follow and understand. Great tutorial!
@jackienorena6843
@jackienorena6843 3 года назад
Thank you for making it so simple to use.
@mehdibellatig8776
@mehdibellatig8776 5 лет назад
Amazing share Ben, thank you !
@antoinettehunt971
@antoinettehunt971 4 года назад
This was awesome but I became a little lost so THANK SO MUCH for the sample calendar. You're Awesome!
@patineishon
@patineishon 4 года назад
Thanks a lot, specially for the template! Hope you're doing fine during this time. Wish you the best.
@Thashi179
@Thashi179 3 года назад
Thank you for being so generous! appreciate you sharing the template :)
@thankjeb
@thankjeb 5 лет назад
Great video! Thank you for this!
@abtextiles912
@abtextiles912 Год назад
Thanks so much Ben, this template and tutorial are just what I needed!
@AwallArtist
@AwallArtist 3 года назад
i truly appreciate this, you literally saved me hours!!!
@Eric-kg5mh
@Eric-kg5mh 4 года назад
Thank you! This is beyond helpful.
@xzombee4168
@xzombee4168 3 года назад
Thank you so much for this! i have used this calendar often! i just have a question about the lookup, i am unsure how to use this feature
@orangedragon1238
@orangedragon1238 10 месяцев назад
fantastic tutorial!! super clear and prob the most useful thing ive ever made so far. thank you ben for making this video, truly appreciate it :)
@sweetsurrenderspaqualityba4240
@sweetsurrenderspaqualityba4240 5 месяцев назад
So helpful and easy to follow, thank you very much for sharing.
@mariaeduardasanto7329
@mariaeduardasanto7329 3 года назад
Thank youuu! You just saved me! U dont have idea, spend many hours looking for a sheet like this!
@makalam4832
@makalam4832 4 года назад
Thank you very very much!!! You saved my day at work.
@TRESSS
@TRESSS 2 года назад
Thank you Ben, this really helped me make a workout schedule!
@gabrielajuarezs
@gabrielajuarezs 4 года назад
OMG This is so helpful!!! Why is this your only video? :( Post more!!!! Please!!!
@kevingoez9206
@kevingoez9206 3 года назад
how can I thank you enough??? It was all super clear and very simple to follow. Thanks so much!!
@helenavantsant7783
@helenavantsant7783 4 года назад
That you so much for this video! and for creating the template, it's a huge help and time saver!
@belindalockett411
@belindalockett411 3 года назад
Great Tutorial! Very easy to follow, learned a lot of cool tricks.
@TheSavingSecret
@TheSavingSecret 2 года назад
Great Video!! Built it and love it.
@vanessaapodaca3039
@vanessaapodaca3039 3 года назад
Thanks for the template! This is really helpful for my work!
@veekooper
@veekooper 3 года назад
Thank you so much, this honestly helped me so much
@NicholasAHanley
@NicholasAHanley 2 года назад
Thank you so much, You are powerful and you will accomplish everything this year. 🙏🏿🙏🏿
@Flowium
@Flowium 4 года назад
Practical tutorial. Thank you for sharing!
@nextdoordreamer
@nextdoordreamer 2 года назад
Hi! Thank you, this is so helpful. But I have a question. I saw the updated version of the calendar and was wondering if it's possible to add a column on the left for time? Like, 10:00 - 11:00 then 11:00 - 12:00 and so on. Will that affect any of the formulae?
@samarthk4130
@samarthk4130 3 года назад
Just what I needed, thanks!
@ruthiechagoya2570
@ruthiechagoya2570 3 года назад
Extremely helpful! Thank you so much!!
@neliodiassantos
@neliodiassantos 2 года назад
Thank for your work! Help me very much!
@smo2497
@smo2497 2 года назад
Great video!! This is perfect for the content calendar I'm building.
@robertoarguello3142
@robertoarguello3142 2 года назад
Thank you, Ben. Very helpful.
@god604
@god604 3 года назад
Hey Ben! I had such trouble trying to figure out how to do this on my own, but after watching your vid I was able to get the hang of it and actually create my own calendar! I appreciate your tutorial video as it has helped me quite a bit! Hope you bring out more tutorial videos soon!
@ecpi.x
@ecpi.x 2 года назад
just what i needed!!! thanks so much
@selomitagwireyi3288
@selomitagwireyi3288 2 года назад
This was really helpful. Thank you
@kendrahoffman9036
@kendrahoffman9036 Год назад
Thank you soooooo 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.
@virenageorgieva4136
@virenageorgieva4136 4 года назад
Amazing 👌 great sheet and super helpful
@simonmcdonald4124
@simonmcdonald4124 4 года назад
Very generous of you - thank you! May the karma Gods be kind to you!
@She_Builds_Kingdom_Marriages
Thank you so much for this. Your area of expertise saved me tons of time! You rock!!!!
@PriyaKumari-wm5ik
@PriyaKumari-wm5ik Год назад
Thank you so much Ben! This video tutorial was a massive help! Can't thank you enough :D
@ShawnWeekly
@ShawnWeekly 5 лет назад
This is so helpful! Thanks.
@BkSathesh
@BkSathesh 3 года назад
Just what I needed. Thank you very very much!!!!
@amazingytvideos5214
@amazingytvideos5214 Год назад
THANK YOU very much for this tutorial!!!
@arungulati4276
@arungulati4276 3 года назад
Thank you Ben for this wonderful and informative tutorial. Is there a way to add multiple tasks in the same day? I tried with existing formulae but it doesnt take multiple entries
@malikastar9265
@malikastar9265 Год назад
Thank you Ben, That was genius and very helpful ! I wonder why is there only one video in your ytb channel, thank you so much again :)
@dannysadana5775
@dannysadana5775 4 года назад
Thank you Ben, Good job!
@Velimouree
@Velimouree 3 года назад
thank you so much I had to do this for an assignment that was due today I was gonna cry bless you 😪✋
@joeuitvlugt8282
@joeuitvlugt8282 4 года назад
This is great! I added this to my own sheet template. One thing I can't figure out is how to add conditional formatting (COLOUR) to the Calendar tab event based on a colour added from conditional formatting to the event list tab. Do you have a formula for this? THANKS!
@danyurrealtor
@danyurrealtor 2 года назад
Great Video Ben, Thank you!
@faizanhari4913
@faizanhari4913 Год назад
Thankyou for sharing the template!
@brittanyfernandez7191
@brittanyfernandez7191 4 года назад
Thank you so much for this! I have been doing a monthly budget on pen and paper, and am trying to take everything digital so I can stop printing so much. :) This leads me to my question... is there a way to document reoccurring bills each month? I want the 1st of every month to reflect that rent is due, but when I add it to the 1st of a month, when I move onto the next month, it is there, but in the same cell, rather than on the specific date that I am wanting. Is there a formula for that? Any help is appreciated!
@ronaldjohnson_ita
@ronaldjohnson_ita 5 лет назад
Thanks, very helpful. How do you create a dynamic calendar "with" dynamic drop downs. So, if I have a set list of drop downs, and I change the month those drop-downs will follow the days of the calendar in order. I am trying to create a cleaning schedule, and M-Friday a team-member is assigned to clean, I want it to be able to automatically assign team-members based on Mon-Friday if I change the date. Is this possible?
@LaizyDaisy
@LaizyDaisy 4 года назад
Brilliant! Thank you for sharing!
Далее
How to Build a Dynamic Calendar in Google Sheets
10:37
How to Use Google Calendar Effectively | Full Tutorial
22:21
HOW DID SHE WIN??
00:49
Просмотров 16 млн
Google Sheets - Calendar Template
31:34
Просмотров 147 тыс.
How to Create a Gantt Chart in Google Sheets
10:41
Просмотров 895 тыс.