Thank you for the template!

Hello help me please 🥺. I created dynamic calendar but how i calculated work's hours on dynamic calendar for per month

Hi there, great video. Did the exact same steps and it worked. However, there came a point when the calendar won't show anything. It happened with September 2024. The calendar was showing up results till August 2024 but went blank after September 2024

If the 1st lands on a Sunday then it shades the rest of the month? How do I fix that?

You're a lifesaver!!!! THANK YOU! <3 <3 <3

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!!!

Hi. I need a schedule that starts on a saturday. So, i decided to give it a go myself. Everything was smooth until it was time to test month changes. The inital day will appear, but the rest don't. Why might this be?

Thank you so much dear. It helped me a lot to fix some of my problems. Many thanks.🤗🙏

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

Hi, how to add cells within one day? Like a to do list for the day. thank you.

need a 2024 version

Thanks. That really helps.

The formula says error due to circular dependency. How to resolve this ?

Is there a way to make events and formulas repeat on a certain day of the month? Example, Mortgage is due on the first of the month. I'm trying to make a financial calendar that will add up bills due and subtract bills from a total into a different cell. Not only does the event need to repeat but the =minus and =sum formulas need to repeat conditionally. I hope that made some sort of sense.

What would happen if you wanted it to change automatically like if you typed in April 2024 would the calendar change to april 2024? Or not

Thank you 🎉

Thank you!

Loved your video and following along with you in creating my calendar i had a little hiccup with the months Sept and Dec for some reason but i got them fixed.

So helpful and easy to follow, thank you very much for sharing.

I've had few understanding on calendar and after watching this I am very confused.

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!

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!

Hi Ben, is it possible to have two different events show up on the same date on the calendar? We are running into issues when we try to make that happen.

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

thank you so so much, It helps me alot

My calendar isn’t updating to this year 2023. Can you help send me a Calendar template for 2023

thank you very much for your helpful content

Has anyone figured out the code when the first starts on a Sunday? October 2023 is the only month not working for me. I'm stumped

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 :)

I walked with you right through the whole procedure but once we came to the 31st which worked fine and then the next 4 cells were blank but my 5th cell has a one in it even though I copied the previous cell across not sure why I get a 1 in there.

I cant get the " =IF(WEEKDAY($A1)=COLUMN(),1,IF(ABS(C3)>0,C3+1)) statement to work in my google sheet....not sure what I'm doing wrong

Just curious if you wanted to highlight the current cell based on todays date what would be the best way to input that information? I tried the =AND($A2+A4-1=Today()) but it is not wanting to work

Very helpful. Really appreciate the efforts you have put in to bring out this document.

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

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 ^^

THANK YOU very much for this tutorial!!!

How can you get the day number to stay in the top right corner of the cell?

hi thank u sm! when i type text into the box i can't type more than a single row, do u know how i could fix this?

Thank you so much!

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

God bless you

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. :)

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:)

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.

At 15:33, I didn't get the function for WEEKDAY. Does anyone get it? Please help out!. Thanks.

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?

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

For anyone that would like a coherent explanation click the link below - she explains it much more succinctly. Hopefully, Gentle Ben is resting peacefully in his Calgary group home! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gc9BnyusFd4.html

Thank you so much Ben! This video tutorial was a massive help! Can't thank you enough :D

How do I do it so my events don't show up in every month?