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.
@ardianifa2 жыл бұрын
thank you so much!
@shannonvillines57034 жыл бұрын
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!!
@aurelieroque200611 ай бұрын
4 years later, and this was SUCH A HUUUUUUUGE HELP. I cannot thank you enough.
@elisabethfesler88783 жыл бұрын
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
@kcron133 жыл бұрын
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 :)
@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. :)
@soniarao87004 жыл бұрын
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!
@user-qd1uo1pq7l9 ай бұрын
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!
@mikeramarao4 жыл бұрын
Love the tutorial. So crisp and clear! This is the kind of teaching that people need for learning more! Thank you!
@GTAHomeGuy4 жыл бұрын
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!
@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
@AdrienneWalton-ck3ei4 ай бұрын
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!!!
@sambrunt24573 жыл бұрын
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
@shanaepaulino1524 жыл бұрын
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! :)
@dwdanceStudio2 жыл бұрын
Hello Mr. Ben, I just wanted to say, that your video has educated me, a little more. Have a great day! - Hans
@biblicalresourceswithgwend25614 жыл бұрын
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
@tmrfoushee3 жыл бұрын
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!
@falielballo-allo33273 жыл бұрын
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
@kendrahoffman90362 жыл бұрын
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.
@todd59634 жыл бұрын
This was super fun to do and I learned a lot! You went at a perfect pace. Thanks so much!
@rachelvelasquez52014 жыл бұрын
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!!!
@warrenzonator2 жыл бұрын
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
@gen37034 жыл бұрын
Thank you so much! I just watched your tutorial and created a full year calendar thanks to your detailed video.
@mariaeduardasanto73293 жыл бұрын
Thank youuu! You just saved me! U dont have idea, spend many hours looking for a sheet like this!
@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:)
@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 ^^
@loustj78003 жыл бұрын
How can I add more that one appointment in a square so that it looks like a list of things i need to do? Thank you
@kimvicuna51383 жыл бұрын
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.
@JSmithOLMC4 жыл бұрын
Thank you for the easy to follow step by step guide (and the link in the description)!
@sweetsurrenderspaqualityba42407 ай бұрын
So helpful and easy to follow, thank you very much for sharing.
@adarshsharma5608 Жыл бұрын
Very helpful. Really appreciate the efforts you have put in to bring out this document.
@god6043 жыл бұрын
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!
@orangedragon1238 Жыл бұрын
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 :)
@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!
@pizzabella42573 жыл бұрын
The template is everything we needed! Thanks so much for this. You're the best!
@Maigue-tm9rg3 жыл бұрын
thank you so much for the tutorial. i've been wanting to learn this for the longest time. great work!
@aixrynx Жыл бұрын
Wow, 3 years ago. Thanks enormously!
@HeyBear4 жыл бұрын
Thank you, Ben. Exactly what I needed!
@eyesforpurple4 жыл бұрын
Thank you for the detailed breakdown! I love my new calendar :)
@vishwanara58594 ай бұрын
Thank you so much dear. It helped me a lot to fix some of my problems. Many thanks.🤗🙏
@ons5854 жыл бұрын
For the linked calendar, how do you list multiple events on the same date? For example, if Event 1 and Event 2 take place on 6/1/2020, how do you make it so the calendar for that date lists both events on calendar cell 6/1/2020? Thank you for your help!
@LNNordang3 жыл бұрын
Perfect, ty very much for the detailed description and link to the finished sheet.
@gabrielajuarezs4 жыл бұрын
OMG This is so helpful!!! Why is this your only video? :( Post more!!!! Please!!!
@theashleyshow78153 жыл бұрын
Hey I really hope you reply! I watched your video it helped me a lot with creating a calendar for the coaches at my job! When I want to write something under a day how can I write multiple things in separate text boxes. Or hit enter without it going to a new box just to separate the events under one day? It all types as one paragraph.
@CalgaryBen3 жыл бұрын
If you need multiple cells per day, it would have to be designed with that in mind from the outset. If you just want multiple lines of text in a single cell, end each line by pressing Alt-Enter instead of just pressing Enter.
@theashleyshow78153 жыл бұрын
@@CalgaryBen YES! Thank you!! Alt-Enter works!
@EzraOmoke3 жыл бұрын
This has been helpful. How can I populate more than one event on one day in the calendar?
@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 :)
@She_Builds_Kingdom_Marriages2 жыл бұрын
Thank you so much for this. Your area of expertise saved me tons of time! You rock!!!!
@Velimouree3 жыл бұрын
thank you so much I had to do this for an assignment that was due today I was gonna cry bless you 😪✋
@TRESSS2 жыл бұрын
Thank you Ben, this really helped me make a workout schedule!
@nextdoordreamer2 жыл бұрын
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?
@antoinettehunt9714 жыл бұрын
This was awesome but I became a little lost so THANK SO MUCH for the sample calendar. You're Awesome!
@abtextiles912 Жыл бұрын
Thanks so much Ben, this template and tutorial are just what I needed!
@NicholasAHanley2 жыл бұрын
Thank you so much, You are powerful and you will accomplish everything this year. 🙏🏿🙏🏿
@wizzywidge90394 жыл бұрын
Thanks! This was a very helpful video. Making a calendar for a group to share. Learned a lot!
@tiffanyhogue11863 жыл бұрын
Thank you! This video was easy to follow and understand. Great tutorial!
@jackienorena68433 жыл бұрын
Thank you for making it so simple to use.
@wilsononu21623 жыл бұрын
Ben, thank you so much for this. Truly helpful. All the best.
@simonmcdonald41244 жыл бұрын
Very generous of you - thank you! May the karma Gods be kind to you!
@PriyaKumari-wm5ik Жыл бұрын
Thank you so much Ben! This video tutorial was a massive help! Can't thank you enough :D
@kevingoez92064 жыл бұрын
how can I thank you enough??? It was all super clear and very simple to follow. Thanks so much!!
@josephzhao3424 жыл бұрын
Hi! I have a problem with my calendar I was hoping to get the solution for. You know how when you typed in a different month and year at the top, the calendar automatically changed and the days would appear for that month? For me, that doesnt happen. instead the days just disappear. i followed your steps exactly as shown and i cant pinpoint my mistake. do you have any idea as to how to fix it?
@laha444 жыл бұрын
yes! this happens to me too when the 1st of the month lands on a Sunday. Any advice on how to correct this would be amazing!
@techyy99624 жыл бұрын
the formular that he put for saturday, copy and paste that onto the first week monday to saturday. That should fix it
@Thashi1793 жыл бұрын
Thank you for being so generous! appreciate you sharing the template :)
@Kristin-hn5eu4 жыл бұрын
Your voice gives me ASMR.
@chaplainmattsanders48847 ай бұрын
Thanks so much!! Very helpful. One question: For some reason, the months in which “1” starts on SUNDAY are not working properly (all the other months look great). Any hints on how that might be fixed? Thnx again!
@dimpleadalja21983 жыл бұрын
Great video. However, what if the format I am working on is from Mon-Sun how do I use the if weekday formula then? Thank you
@CalgaryBen3 жыл бұрын
Please refer to the sample document in the description, and go to the tab labeled "January 2019 - alt (Monday as first day of week)". You can then make a copy of the template document for your own uses.
@amazingytvideos5214 Жыл бұрын
THANK YOU very much for this tutorial!!!
@smo24972 жыл бұрын
Great video!! This is perfect for the content calendar I'm building.
@franciscobaraquel3 жыл бұрын
Still relevant in 2021. Thank you!
@cryptonursery50273 жыл бұрын
thank you so much for sharing and teaching this. made my own as i watched and works perfectly for what i needed!
@rhphares3 жыл бұрын
This calendar is great and saved me MUCH time on a project that I'm working on. One question, On the calendar that pulls data from a seperate page, is there a way to get the calendar to show two events in the cell (if I had two items with the same date on the source page)?
@WattooPlays2 жыл бұрын
Hey, did you ever work out a way to do this as i have the exact same question/problem
@DeeKM123 жыл бұрын
This was fantastic. Really saved me lots of time on work projects!
@hmsnyder114 жыл бұрын
What do you do if you need to place the calendar in the middle of the spreadsheet, i.e. the sunday column starts in column "S"?
@YoukoVignau Жыл бұрын
Hi, this is awesome. Thank you for sharing. This had been uploaded for a couple years. Not sure if you will see this. On the event page. You set up a description link to the calendar. What if I have more than 1 event happening on the same day? Let's say "7/4 Acopy delivery" and "7/4 Testing start". The current setup will show only one cell's description. Is there a way can have both of them show on the calendar? Thank you.
@arungulati42763 жыл бұрын
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
@brittanyfernandez71914 жыл бұрын
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!
@brook3518 Жыл бұрын
Hello, this helps a lot on my work. thanks. got some questions. If I have my clients' reservation tables in the other sheets, Can it be automatically add to the calendar?
@deeptitaneja19912 жыл бұрын
Hey Ben, thank you for this tutorial. This is working for the starting columns but if I am trying to put this same formula in another columns (for example I want my calendar for feb month in Column I to O) then it is not working. Could you or anyone else please tell me am I doing something wrong or is there any other issue.
@JourdanAshley2 жыл бұрын
I’m having this issue as well!!
@CalgaryBen2 жыл бұрын
In the sample/template I provided, there is a tab along the bottom called "2019 - 3x4". Click on that, and you'll see an example showing exactly what you're trying to do. Basically some of the references need to be updated to account for the column offset. I'd recommend just making a copy of the template and modifying it to your needs.
@deeptitaneja19912 жыл бұрын
Hey Ben, Thank you so much for replying 😊
@robertoarguello31423 жыл бұрын
Thank you, Ben. Very helpful.
@gabrielpatrick15815 жыл бұрын
your voice is oddly soothing...kinda like Christopher cross.
@CalgaryBen5 жыл бұрын
Thanks! That's high praise! And I agree with the "oddly" part, since I haven't heard that before. Soothing/boring is a good way to put my kids to sleep... ;-P
@ShelitaRN4 жыл бұрын
Wow! thank you so much, this is amazing, I'm just gonna use the template it saved me so much time! Thank you again!
@ItssRapzz4 ай бұрын
Thanks for the amazing tutorial, this is exactly what i was looking for. However, when i am trying to copy stack the months around the spread sheet 4x4 i running in to issues with the days changing order, formulas not copying across etc. :( any help would be appreciated
@georgieanngetton3 жыл бұрын
Thank you so much for this! I have been looking for how to do this and you gave a perfect explanation
@anianitaanita2 жыл бұрын
You are a life saviour! Thank you so much!
@huynhhoatran72723 жыл бұрын
Thank you! It was very helpful. Saved me a lot of time :)
@mashton3694 жыл бұрын
Can you do a video on how you set up the "2019 Event List" and the "2019 - Linked to Event List"?
@patineishon4 жыл бұрын
Thanks a lot, specially for the template! Hope you're doing fine during this time. Wish you the best.
@frederickahannor3403 жыл бұрын
This was awesome!!! The only thing I had to differently was when I added my dates, I had to do =Column(B1) instead of just having ().
@vanessaapodaca30393 жыл бұрын
Thanks for the template! This is really helpful for my work!
@yawnoir45814 жыл бұрын
Thanks. I wanted to create something from scratch and learn and adapt from it.
@narutoninja16674 жыл бұрын
Hi! I have completed my calendar following your tutorial and it works for the Month/year of March 2019. However, when i type in a different month like you did, April, June July, or any other month/year, the calendar will display the 1 on the correct day, however the days after the 1 disappear. Can anybody help me. I've gone into the working template provided, and noticed that the entered formulas are a little bit different than initially instructed on the tutorial. I need some help so I can make a School/subject calendar for my son being home schooled due to Covid-19.
@ekpenosunbor15192 жыл бұрын
Great video, Ben. Thank you so much.
@gubachmann3 жыл бұрын
Thank you so much! This was just awesome. I would like to know if its possible to schedule work on blank spaces dynamically. I mean, i have clients appointments in a collum, and I would like to see those appointments at the callendar view.
@pasadenagrifter Жыл бұрын
Hi Ben, This is such a nice tutorial. I only have one issue... I started my Calendar in Jan. 2023 and the 1st on the year starts on a Sunday. I followed all of your steps and made the adjustment where necessary because I'm starting in 2023. When I went to change the month to Feb. or Mar. , all days before the 1st of each month except Sunday say FALSE. Any way you can help me correct this? Thank you
@faizanhari4913 Жыл бұрын
Thankyou for sharing the template!
@thecalmcoolcollected60872 жыл бұрын
Hi Ben! This is SUPER HELPFUL! Thank you for making this video. A couple questions- can you keep multiple event lists to update on one calendar? And also are you for hire to help create customized calendars? Please let me know! Thank you!
@viradokumen68473 жыл бұрын
thank you so much for your helping, may goodness will return to you :D you save my life
@purpletyc3 жыл бұрын
Thank you, this took me some time and I really LOVE IT!!!! I need to see your other videos. UPDATAE: I don't see you have other videos