How to Create a Dynamic Appointment Calendar in Google Sheets 

I'm so glad you had such an awesome time building this spreadsheet!

That's amazing to hear! Thank you for your feedback!

That's so amazing to hear! Thank you for your feedback. I will do my best to keep it up! 😄👍

So glad to hear your found this tutorial helpful! 😊

Thank you so much for your kind comment! I'm so glad you enjoy my teaching style in these videos. For your question, have you thought about inputting the in time and then the out time below it in the cells below each day? Or were you hoping for some other way to do it?

@@spreadsheetlife This was exactly what I did! Thank you so much for your help 🙏🏾

Yay!! That's amazing! I'm so glad it worked out! 😄👍

That's so amazing to hear! Thanks for sharing. Also, for your question - send me an email and we can discuss your ideas for a dynamic weekly calendar. I might be able to provide some tips on that front.

Thank you! Email sent :) @@spreadsheetlife

You would have to take a different approach to pull off what you're describing unfortunately. My advice would be to copy the worksheet for new months, and then store your appointments on each relevant tab. I hope this helps!

That's a good question! Here is my suggestion. Make 11 copies of the worksheet. Then you can set up each tab to be a different month, and add appointments accordingly. I hope this makes sense!

To add events that change dynamically with the calendar, check out part two! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-CBWy5MxbNO0.html

It might be possible, but solving something like this will also take some work. If you'd like, send me an email at info@spreadsheetlife.com, and we can better discuss your options there. 😊👍

You know, I was curious about that - how much I should have gone into the explanation of the functions and formulas. So thank you so much for the feedback. I will take it into account and do my best to make the next video even better!! 😊

Weekly based on time values. Hmmm...could you be a little more specific? I'm sorry that I don't quite understand.

Yes, you can create this same template in Excel. A few things will be a little bit different like the conditional formatting. But mostly, it's the same.

You are very welcome! 😄 And have you taken a look at part two? It might hold the answer to your question. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-CBWy5MxbNO0.html

@@spreadsheetlife I have checked it and it was very helpful. However, I wanted to learn how to write directly on the corresponding date rather than entering the date and task on a different sheet. Would it be possible to do a tutorial on that? Thank you for your help.

Gotcha! Unfortunately, it would not be easy to set the spreadsheet up in a way where you can type the information directly into the cells below each date, and then have these cells also change when you change the dates. It might be possible to build something like this through the implementation of Google Apps Script, but doing something like this is a little beyond the scope of the videos I'd like to create for this channel, at least at this time. I try my best to keep the videos balanced between beginner friendly and also complex enough so even seasoned spreadsheet users can learn new things too. I hope this all makes sense, and I'm sorry that I can't provide the exact solution you are looking for.

Yes. The data validation that I show you how to add in the video creates a dropdown list for the month selection cell. I hope this helps clarify! 😄👍

By merge, do you mean place both worksheet tabs in the same spreadsheet file?

@@spreadsheetlife Oh, no, let me try to explain it better. I'm a college student and I have multiple classes a day in a school week. For 2023, I got a template for a regular calendar and I'd manually type under each day the classes I didn't go to, and did a simple sum under each month for each of my classes to keep track of my attendance for the semester. The thing is, I have different classes in one day, and sometimes I might go to one, but skip another, and I'm not sure how I'd put that into the formulas. I tried yesterday for four hours to fit your attendance tracker inside this one, but I really don't know how to. Did it make sense?

Okedokie. I think I see what you mean. Unfortunately, I don't think there is any easy way to merge the calendar with the attendance tracker to accomplish what you described. So will need a different solution. If you'd like, send me an email, and we can talk about some ideas that might help! spreadsheetlife.com/contact/

@@spreadsheetlife you are so sweet! Ty!

Thank you for your kind words. And you are very welcome. 😊

So when you change the month and year, it will only update the date values. The information that you add in the cells below the dates with remain the same. I'm sorry I don't make that more clear in the video.

I'm sorry, but I don't understand your question. Which cell are you selecting? Which cell do you want to see a full date in?

@@spreadsheetlife Hi! Básicamente sería Mostrar el valor de la celda activa en otra celda en Excel. Saludos!!

Ok. I think I understand. Unfortunately, I do not know a way to dynamically display the value of the active cell in another cell without adding Google App Script code to the spreadsheet. However, you can change the way dates are displayed in any cell by changing the number formatting. I'm sorry I don't have a better answer to your question.

Whenever you change the Year and Month, only the dates will change. Anything you write in as notes will stay in those cells. I'm sorry I did not clarify this in the video.

@@spreadsheetlife I hope you can share as well that even the notes will included upon changing the months and year please. Thank you!

I will make note of that and see what I can come up with in the future! Maybe I will make a follow up video! 😊👍

Was there an uodate for this? Following. Mins is the same. I dont want every note to be repeating in each month. As we use it for Holiday tracker. Thank you. Hope you can help.

Yes. The follow up video is here. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-CBWy5MxbNO0.html

Hi there. You are correct, the WEEKDAY function only takes two arguments. Which part of the video are you confused with? Can you give me a timestamp?

15:18, that whole formula.

Are you asking about the formula that begins at 8:20? If so, you will see that that WEEKDAY function is used several times throughout this formula, but only one argument is entered each time. The outer function in the formula is the IF function, which accepts three arguments. Perhaps this is where the confusion is for you? I hope this helps.