Thank you so much i did two calendars one for a wedding calendar and another for a Christmas calendar. I made mine just a little different, I made mine into a calendar checklist tracker. Love how detailed you explain yiur tutorials. Your voice is very calming 😊
Thank you for your kind words. 😊 It's so amazing to hear that you were not only able to work through the tutorial but transform the calendar into templates that work just the way you want them to. That's awesome!! 😄 Thank you for sharing!
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?
Thank you soo much for the tutorial. Would it be possible to create a tutorial on how to keep the page (note section) blank when changing the date while keeping the previous notes saved to their corresponding section (date)?
@@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, this should be replicable in Excel. However, I've also done another calendar video based in Excel. You can see it via the link below. th-cam.com/video/hGdAquV5aNw/w-d-xo.htmlsi=rTV2q2kDgJdkd6_D
Thank you so much for this video! I was able to finally make my monthly calendar the way I would like! Is it possible to create dynamic weekly calendars to match the month as well? Any tips or possibly a tutorial in the future for this? Thanks again for a high quality tutorial!
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.
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!! 😊
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.
Hello. Thank you for this video. I was able to create this template on Excel with no issues (other than the difference with conditional formatting). I had a question though. How do I make it so when I switch between the months, it will only display the events for that particular month vs having the events always show no matter what month you choose?
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!
Unfortunately, whenever you change the month or year, only the dates will change. Anything that you type into the cells below the dates will not change. If you'd like to learn how to add events that also change on the calendar whenever you update the month and year, then I advise watching Part 2 of this video. 😊👍 th-cam.com/video/CBWy5MxbNO0/w-d-xo.html
Hi, your videos are really good, but i cannot find anything near what im trying to do and wondered if you could help? i need a dynamic calendar that can be accessed by 20+people but so they cannot edit each others inputs. the dynamic calender can then per day set that data to another sheet which is locked by 'Admin' and can they see all data collectively. is this possible?
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. 😊👍
i have a question. if i will put my schedules there by the month of july and i have another schedules in next month. so in b2 is july with my schedules and if i want to change the month in b2 into august then why does my schedules in july is still the same in august. how to fix these. thankyou
hello! Need Help! If i add an event somewhere in January it shows up in the same exact place for all the other months! How can i ensure it only shows up in January and nowhere else??
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!
@@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/
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.
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.
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.
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.
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.
This was so much fun!!I never thought I'd be able to make something like this! Thank you as always for such a fun time!
I'm so glad you had such an awesome time building this spreadsheet!
This was very helpful. Thank you for your detailed step-by-step instructions.
That's amazing to hear! Thank you for your feedback!
Thank you so much i did two calendars one for a wedding calendar and another for a Christmas calendar. I made mine just a little different, I made mine into a calendar checklist tracker. Love how detailed you explain yiur tutorials. Your voice is very calming 😊
Thank you for your kind words. 😊
It's so amazing to hear that you were not only able to work through the tutorial but transform the calendar into templates that work just the way you want them to. That's awesome!! 😄 Thank you for sharing!
I hope your a teacher because you have the gift.
Thank you so much for your kind words. 😊
I love how you slowly teach everything in your videos🙌🏾. Is there a way to include time in and time out in this template? Your response is appreciated
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! 😄👍
This is truly helpful. Thank you so much for this!!!!!
I'm so happy to hear that this video was helpful to you!! Thank you for letting me know! 😊
Seriously amazing, ty so much. You explain things at a great pace, and I really appreciate the goal to get the goal done. 👍
That's so amazing to hear! Thank you for your feedback. I will do my best to keep it up! 😄👍
God bless for this tutorial. It's really been helpful
So glad to hear your found this tutorial helpful! 😊
Thanks your videos are superb.
Thank you for your kind words. Thank you for watching! 😊
Thank you soo much for the tutorial. Would it be possible to create a tutorial on how to keep the page (note section) blank when changing the date while keeping the previous notes saved to their corresponding section (date)?
You are very welcome! 😄
And have you taken a look at part two? It might hold the answer to your question.
th-cam.com/video/CBWy5MxbNO0/w-d-xo.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.
Thank you for this tutorial....Can normal window excel be used to achieve this as well
Yes, this should be replicable in Excel. However, I've also done another calendar video based in Excel. You can see it via the link below.
th-cam.com/video/hGdAquV5aNw/w-d-xo.htmlsi=rTV2q2kDgJdkd6_D
Thank you so much for this video! I was able to finally make my monthly calendar the way I would like! Is it possible to create dynamic weekly calendars to match the month as well? Any tips or possibly a tutorial in the future for this? Thanks again for a high quality tutorial!
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
I wish you have explained further why you used those functions and formulas, otherwise it was good
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!! 😊
Can I create this in Excel aswell?
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.
Excellent! How would I do weekly based on time values?
Weekly based on time values. Hmmm...could you be a little more specific? I'm sorry that I don't quite understand.
Hello. Thank you for this video. I was able to create this template on Excel with no issues (other than the difference with conditional formatting). I had a question though. How do I make it so when I switch between the months, it will only display the events for that particular month vs having the events always show no matter what month you choose?
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!
thank you i have a problem i find appointement of octobre in all the months
Unfortunately, whenever you change the month or year, only the dates will change. Anything that you type into the cells below the dates will not change.
If you'd like to learn how to add events that also change on the calendar whenever you update the month and year, then I advise watching Part 2 of this video. 😊👍
th-cam.com/video/CBWy5MxbNO0/w-d-xo.html
Hi, your videos are really good, but i cannot find anything near what im trying to do and wondered if you could help? i need a dynamic calendar that can be accessed by 20+people but so they cannot edit each others inputs. the dynamic calender can then per day set that data to another sheet which is locked by 'Admin' and can they see all data collectively. is this possible?
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. 😊👍
Can we put dropdown to pick the month
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! 😄👍
i have a question. if i will put my schedules there by the month of july and i have another schedules in next month. so in b2 is july with my schedules and if i want to change the month in b2 into august then why does my schedules in july is still the same in august. how to fix these. thankyou
To add events that change dynamically with the calendar, check out part two!
th-cam.com/video/CBWy5MxbNO0/w-d-xo.html
hello! Need Help! If i add an event somewhere in January it shows up in the same exact place for all the other months! How can i ensure it only shows up in January and nowhere else??
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!
i have a question, i want to add another month to the calendar how do i do that?
You make a copy of the worksheet, and use each worksheet as a different month. I hope this helps.
The xmatch keeps brining N/A. It says did not find value in Xmatch and i was putting the right functions
If you reply to this comment with the formula your struggling with (as you've written it), I can take a look at it for you.
Is is possible to merge this template to your attendance tracker one?
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. 😊
Cómo hago para que en una celda me muestre el día que estoy seleccionando? o la fecha completa, saludos
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.
I still cant use the formula always error why?
It's hard to say without more information. Which formula are you struggling with? Could you paste your formula here for me to see?
Why is my events coping to every month when I add it in
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.
My notes didn’t save base on the month and year I wrote. When I put different month my notes was still there
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. th-cam.com/video/CBWy5MxbNO0/w-d-xo.html
I am having a problem when it says WEEKDAY only takes 2 arguments, but this is argument number 3
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.
hola, como puedo aumentar el año 2025 al calendario
Just type in the year 2025, and the calendar will update automatically. 👍