This is what exactly what I was looking for. Thanks!

@spreadsheetlife

Ай бұрын

That's amazing!! I'm so glad you came across this video! 😄👍

EUREKA! I figured it out! Thank you so much for making this video!

@spreadsheetlife

13 күн бұрын

Thanks for watching! I'm so glad you enjoyed the video and also figured it out! 😄

Thanks alot,. Can you add hourly appointments (time input) and highlighted on the calendar?

@spreadsheetlife

8 күн бұрын

I found your other comment for the part 2 video and gave you a response there. 😊👍

Excellent teacher

@spreadsheetlife

Ай бұрын

😊👍

This is perfect and exactly what I need! However, I can't get the prior month to grey out. Do I type in MONTH manually, or is there a specific button I should click when writing the formula.

@spreadsheetlife

10 күн бұрын

So awesome to hear!! 😄 As for the conditional formatting formula to get the prior month to grey out, you have to type in MONTH manually when writing this formula. And be sure that you have your references and the dollar signs correct as well.

Hello Ryan, Thank you so much for do this organised calendar, I am struggling with the formula first one Text saying Left then =Date(C3 as etc I am unable to get that to work, what should they left bar say in formula form? When I do = and given formula it gives me error saying I need to put ' at the front, that doesn't work either...? Are maybe able to do the formula so I can copy it into my sheet...? Thanks a million for doing this for us amateurs

@spreadsheetlife

3 күн бұрын

Hi there! I'm super glad you've enjoyed the video, but I'm sorry that you're struggling with the formula. To make it easier for me to help, send me an email at info@spreadsheetlife.com. Attach your file, and remind me what you're struggling with in the email.

@Bjorg20

3 күн бұрын

@@spreadsheetlife I’ve just send you an email…🤞🏻

@spreadsheetlife

2 күн бұрын

I got your email. You can expect a response here in a little bit!

@Bjorg20

Күн бұрын

I just wanted to express my deep gratitude for the extraordinary assistance you provided. Your valuable insights have truly opened my eyes to a fresh perspective, and the individual behind the KZread channel is a remarkably humble person. I never anticipated receiving such overwhelming support from you. Your kindness and generosity are truly remarkable. Please continue to inspire others with your outstanding work. 👩🏻‍💻

is there a way to colour code the events please?

@spreadsheetlife

8 күн бұрын

Hi there! I found your other comment for the Part 2 video. I gave you a response there. 😊👍

Wow! Can u do this in google sheet?

@spreadsheetlife

Ай бұрын

Yes, for sure! Check out this video! kzread.info/dash/bejne/lKuX18mhqbabgLQ.html