So I’m 76 and have worked using Excel in my former work place. Since retiring and rather than sitting on the Couch I took up learning VBA. Found some channels but most presenters rush along with the instruction. But am so happy to find your channel as you are Cristal Clear when speaking and I found I could keep up with you. Pleased to say developed the Event Calendar which I love. Bonus I now know how to make a Copy after your instruction. My sincere Thanks Ryan and of course I have Subscribed and Liked so will staying with your channel and checking out previous videos. 👍👏
Thank you so much for your kind words and feedback. It's incredible to hear that my work is so appreciated. Thank you. You really made my day. 😊 I'll do my very best to keep up the good work! 👍
THANKS SO MUCH!!! These tutorials were AWESOME. I'm trying to help a friend who isn't very tech savvy make an updatable events calendar for a nursing home. This is exactly what we need. I do need to figure out how to make each month a separate page and "pretty" it up so she can print it, but this gives me what I need to do it. I would also love to know how to make events not in the current month either not show up or show up in a different color.
I'm so glad that you have gotten so much out of these tutorials. If you are still struggling to figure out those last details, send me an email at info@spreadsheetlife.com, and I may be able to help you figure out those last few things.
This is wonderful tutorial and a very helpful sheet you helped create. BIG Thank You. Only thing missing and I would be great to have, recurring event if there is event every week/biweekly or monthly how to have it once and can show up in calendar
Hello my friend. First of all, thank you very much for the video that you uploaded. Very helpful. As I see, I have to use (;) instead of (,), and I don't know why, but it's OK. But my real problem is that I have an issue when I'm trying to take the events. I don't know if I'm doing anything wrong or what. It returns this: #NAME?
Thanks for your tutorial about dynamic calendar i followed and did it, can you also show how to make appointment schedule for patients where i can see the details next to the calendar and it will change if i click on the specific day on the calendar.I still want the calendar plain as it is. I hope you notice, thank you very much
That's awesome! I'm glad you were able to follow and complete it. As for your question, this sounds like an slightly more involved question. If you'd like, send me an email at info@spreadsheetlife.com, and we can discuss the details there. It's a little easier than chatting through the comments.
Thank you so much! I'm so glad that you enjoyed the tutorial. If you followed along and completed the tutorial, then the calendar will automatically update whether you change the month or the year. So no changes are needed. 👍
I've done this and now on my events sheet (I've extended the dates to include all of next year) there are a bunch that are showing up as ################ How do I fix this?
This error could mean one of two things. 1 - The column is not large enough to display the date. To fix, expand the column width. 2 - You have negative date values. To fix, ensure that there are no negative date values.
Hi this tutorial was helpful. However I’m having trouble with the events not reflecting in the calendar. The though the formula reflects in the calendar. Could you please help me
Of course. First make sure that you changed the table name to 'Events'. As I've helped others, this seems to be the main issue. If that doesn't solve the problem, you are welcome to share your spreadsheet with me by sending me an email at info@speadsheetlife.com and I can take a look at it for you.
Hello, thankyou for the tutorial! It really helped. Can you also also tell me what to do if the event date is like a period for eg: 02nd - 06th October 2024. Please reply
Hi there! I'm so glad that you enjoyed the tutorial. Unfortunately, there isn't an easy way to make an event span multiple days. Probably the best solution is to just re-enter the event for each date in falls on. So enter the same event for all four days.
Thank you sooooooooooooooo much for this great video, please next video if you can add that how we can make the event frequent monthly or Quarterly of Semi annual.
You're very welcome. Since I've already made four calendar videos (two for Excel and two for Google Sheets), I probably won't make another one for a while. But if I do, I'll be sure to include recurring tasks as you have described. I'm sorry it may be a while though.
Hi, Thank you so much for this, it was really helpful. I’m having trouble to connect the events, when I add the IFNA formula it shows the #NAME? Error. I look and every formula seems to add up, so I don’t understand why it shows this. Any advice?
Hmmm...what version of Excel are you working in? If you are working with an older version of Excel, try substituting the IFNA function with the IFERROR function.
@@spreadsheetlife right after I posted the comment I figured it, the name of the table or spreadsheet was not matching what I put on the formula, so everything good! Thank you so much for the reply and what you do on this channel
If you complete the full tutorial, then changing the year selection should automatically change which events show up on the calendar itself. For example, if you change the year from 2024 to 2025, the calendar should also update to show only the 2025 events.
Is there a conditional format formula to make the events that are not in the present month highlight in grey, similar to the dates that are not in the current month?
I have an excel event database (table) that lists the events by rows, not columns (I.e column A date, column B event name, column C event cost). How can it be done ?
You would have to use HLOOKUP or INDEX & MATCH instead of VLOOKUP. If you'd like more info, you are welcome to send me an email at info@spreadsheetlife.com.
What if you want to have more than 5 events per day? I plan to use this for the training courses we plan to offer to employees. We will need to offer different classes throughout the day, some simultaneously, with different trainers.
To add more than five events, you'd need to expand the events table, add space below each date in the calendar, and then copy down and modify the formulas accordingly. So it's certainly possible, but it will take a little bit of work. Let me know if this helps. I'm not sure if it will be enough for what you're describing. But it might be.
So there is "a way" to do something like this, but it is a little involved. If are in interested in learning more about it, send me an email at info@spreadsheetlife.com.
It might be easiest to help via email rather than in the comments. Send me an email at info@spreadsheetlife.com, attach your spreadsheet so I can look at it, and we can go from there! 😊👍
For this particular build, there really isn't an easy way to implement this. It's certainly possible, but it would take a good amount of extra work unfortunately.
Hi I am having trouble getting multiple events to show? What am I doing wrong?☺️ Sure! Here’s your text in English: And when I try to highlight the dates in the months, it goes wrong. I'm unable to make the selected month appear in black.
Hello! what version of Excel are you using? I made my calendar with events on Google sheet but when I downloaded it. I was all messed up. Please help ^_^
Hi there! So this build will work with any version that is Excel 2013 or later. So it's pretty backwards compatible. However, it's not designed for Google Sheets. That's probably why you are having issues. If you'd like to create a similar calendar in Google Sheets, check out this video instead. ruclips.net/video/bwcughyS5PQ/видео.html
@@spreadsheetlife Keep up the good work! ^_^ Do you know about coding in Google Sheets? I was afraid of spreadsheets before I felt like I didn't know how to do them, but thanks to your tutorials, I've learned a lot! I graduated as an I.T. and I'm currently learning how to code in Google Sheets hehe I just felt excited learning new things... if you do, can you please make a tutorial about it? ^_^
I will do my very best to keep it up! 😄👍 As far as coding in Google Sheets, do you mean GAS (Google Apps Script)? If so, that might be a little out of scope for what I'd like this channel to be at the moment since I don't want to the content too far out of reach from beginners and average Google Sheets users. However, it still might be something I consider a little later on. It just may be a while. But I will most definitely take your suggestion into account, and who knows, if enough people ask me about it, I just might do it sooner rather than later. 😄
So this build was specifically designed for Excel. There is a way to design it a little differently for Google Sheets though. The best way I can help is for you to send me an email at info@spreadsheetlife.com with a link to you spreadsheet. Then I can take a look at it and will be better able to help.
I'd love to help. It may be easiest to help via email rather than in the comments depending on the issue. I encourage you to send me an email at info@spreadsheetlife.com, and we can go from there! 😊👍
Did you change the table name of the table on the Events worksheet to 'Events'? This might be the issue. If that doesn't solve it, you can always send me an email at info@spreadsheetlife.com. Attach your spreadsheet, and I can take a look at it for you. 👍
I do have a way you can color code specific types of events, but it is a little tedious. Send me an email at info@spreadsheetlife.com, and I can show you how to do it.
Yes you can. Just add each holiday as an event. Unfortunately, there is no easy way to automate this though. You will have to type in the holiday's manually.
Did you change the table name to "Events"? That might be the issue. Another issue may be your version of Excel. If you are using an older version of Excel, replace the IFNA function with the IFERROR function. I hope this helps.
Oh ok. Then my advice is to get rid of the IFNA function entirely. Even the IFERROR function is not compatible with Excel 2010 I don't think. I'm sorry that is the case.
If I make this all and the last step the ...=IFNA(IF(VLOOKUP(B7, EVENTS,2,FALSE)=0,"",VLOOKUP(B7,EVENTS,2,FALSE)),"") GIVE ME # NAME? ..... WHERE'S the mistake how can I know it
The #NAME? error shows up when Excel does not recognize the text in a formula. This is usually due to a misspelled function. So try to make sure that you have all of the function names spelled correctly.
It could also be that you are using an older version of Excel that does not have the IFNA function. If that's the case, try using the IFERROR function instead.
This was so well done. Even for beginners, you can easily follow along! WELL DONE!!!
Thank you so much for your kind words. It really means a lot! 😊
So I’m 76 and have worked using Excel in my former work place. Since retiring and rather than sitting on the Couch I took up learning VBA. Found some channels but most presenters rush along with the instruction. But am so happy to find your channel as you are Cristal Clear when speaking and I found I could keep up with you. Pleased to say developed the Event Calendar which I love. Bonus I now know how to make a Copy after your instruction. My sincere Thanks Ryan and of course I have Subscribed and Liked so will staying with your channel and checking out previous videos. 👍👏
Thank you so much for your kind words and feedback. It's incredible to hear that my work is so appreciated. Thank you. You really made my day. 😊
I'll do my very best to keep up the good work! 👍
These two tutorials were absolutely awesome. It's going to make our training schedule so much easier to maintain - Thank you!
That's so amazing to hear!! Thank you so much for watching, and I'm super glad you got so much out of them.
You are the absolute best teacher, thank you!
Thank you so much for your kind words. I do my best, and I'm so glad that you enjoyed the video! 😊
THANKS SO MUCH!!! These tutorials were AWESOME. I'm trying to help a friend who isn't very tech savvy make an updatable events calendar for a nursing home. This is exactly what we need. I do need to figure out how to make each month a separate page and "pretty" it up so she can print it, but this gives me what I need to do it. I would also love to know how to make events not in the current month either not show up or show up in a different color.
I'm so glad that you have gotten so much out of these tutorials. If you are still struggling to figure out those last details, send me an email at info@spreadsheetlife.com, and I may be able to help you figure out those last few things.
This was a great tutorial. Thank you so much for sharing. Already put my calendar to good use :)
That's so awesome to hear! Thanks so much for watching! 😄
Thank you so much for this help ! Together with te events this is so good.
I'm so glad that you have enjoyed and gotten value out of this video! 😄👍
It took me awhile, but I did it! I had trouble with making my own table, so I just used an Excel table. Thanks!
I'm so glad you got it all to work out in the end. Awesome job!! 😄👍
This is wonderful tutorial and a very helpful sheet you helped create. BIG Thank You. Only thing missing and I would be great to have, recurring event if there is event every week/biweekly or monthly how to have it once and can show up in calendar
I saw the responses, seems no easy way for reoccurring events. No worries. But again, Great Work and Wonderful Tutorial :)
Thanks so much. Yeah, I'm sorry there isn't an easy solution for recurring events, but I'm so glad that you enjoyed the video!! 😊
Again, Excellent tutorial.
😄👍😊
This was such a good tutorial thank you so much!!
You're very welcome. Thank you for watching! I'm so glad that you enjoyed the tutorial.
Hello my friend. First of all, thank you very much for the video that you uploaded. Very helpful. As I see, I have to use (;) instead of (,), and I don't know why,
but it's OK.
But my real problem is that I have an issue when I'm trying to take the events. I don't know if I'm doing anything wrong or what. It returns this: #NAME?
I saw your email and sent you back a response. 😊👍
Thanks for your tutorial about dynamic calendar i followed and did it, can you also show how to make appointment schedule for patients where i can see the details next to the calendar and it will change if i click on the specific day on the calendar.I still want the calendar plain as it is. I hope you notice, thank you very much
That's awesome! I'm glad you were able to follow and complete it.
As for your question, this sounds like an slightly more involved question. If you'd like, send me an email at info@spreadsheetlife.com, and we can discuss the details there. It's a little easier than chatting through the comments.
Thank you! Great tutorial. How do you make it change with the year?
Thank you so much! I'm so glad that you enjoyed the tutorial. If you followed along and completed the tutorial, then the calendar will automatically update whether you change the month or the year. So no changes are needed. 👍
Amazing - thank you!!
You're very welcome! 😊
Thank you for watching!
I've done this and now on my events sheet (I've extended the dates to include all of next year) there are a bunch that are showing up as ################
How do I fix this?
This error could mean one of two things.
1 - The column is not large enough to display the date. To fix, expand the column width.
2 - You have negative date values. To fix, ensure that there are no negative date values.
That is excellent ! Many thanks
You're very welcome! Thanks for watching! 😊
Hi this tutorial was helpful. However I’m having trouble with the events not reflecting in the calendar. The though the formula reflects in the calendar. Could you please help me
Of course. First make sure that you changed the table name to 'Events'. As I've helped others, this seems to be the main issue. If that doesn't solve the problem, you are welcome to share your spreadsheet with me by sending me an email at info@speadsheetlife.com and I can take a look at it for you.
Hello, thankyou for the tutorial! It really helped. Can you also also tell me what to do if the event date is like a period for eg: 02nd - 06th October 2024. Please reply
Hi there! I'm so glad that you enjoyed the tutorial. Unfortunately, there isn't an easy way to make an event span multiple days. Probably the best solution is to just re-enter the event for each date in falls on. So enter the same event for all four days.
Thank you sooooooooooooooo much for this great video, please next video if you can add that how we can make the event frequent monthly or Quarterly of Semi annual.
You're very welcome. Since I've already made four calendar videos (two for Excel and two for Google Sheets), I probably won't make another one for a while. But if I do, I'll be sure to include recurring tasks as you have described. I'm sorry it may be a while though.
Thanks, can you add time in hourly fashion as well?
You can manually type in the time within the event description, but that's about all you can do for this specific build.
Hi is it possible to use similar formulas for Fiscal Year
Hi there! I'm sorry, I don't think I understand your question. Could you rephrase the question for me?
Hi, Thank you so much for this, it was really helpful. I’m having trouble to connect the events, when I add the IFNA formula it shows the #NAME? Error.
I look and every formula seems to add up, so I don’t understand why it shows this. Any advice?
Hmmm...what version of Excel are you working in? If you are working with an older version of Excel, try substituting the IFNA function with the IFERROR function.
@@spreadsheetlife right after I posted the comment I figured it, the name of the table or spreadsheet was not matching what I put on the formula, so everything good!
Thank you so much for the reply and what you do on this channel
Oh that's awesome! I'm glad you figured it out. 😄
And of course. Thank you for watching and for your support! 😊
Would it be possible to make an events calendar this way but in a weekly view format with events down the side?
Yes, that is definitely possible. You'd have to change several things in your approach, it is certainly possible for sure.
thanks a lot, this really helped !
That's awesome. I'm so glad that this video was helpful! 😄
What is the formula to change the year on the calendar sheet to reflect and update the events from year to year, ie:- 2024 to 2025? Please reply
If you complete the full tutorial, then changing the year selection should automatically change which events show up on the calendar itself. For example, if you change the year from 2024 to 2025, the calendar should also update to show only the 2025 events.
Is there a conditional format formula to make the events that are not in the present month highlight in grey, similar to the dates that are not in the current month?
Yes there is! Send me an email at info@spreadsheetlife.com, and I can show you how to do it.
I have an excel event database (table) that lists the events by rows, not columns (I.e column A date, column B event name, column C event cost). How can it be done ?
You would have to use HLOOKUP or INDEX & MATCH instead of VLOOKUP. If you'd like more info, you are welcome to send me an email at info@spreadsheetlife.com.
Thanks a lot
You're very welcome! 😊
Thank you sooooooo much
You're very welcome!! 😄👍
What if you want to have more than 5 events per day? I plan to use this for the training courses we plan to offer to employees. We will need to offer different classes throughout the day, some simultaneously, with different trainers.
To add more than five events, you'd need to expand the events table, add space below each date in the calendar, and then copy down and modify the formulas accordingly. So it's certainly possible, but it will take a little bit of work. Let me know if this helps.
I'm not sure if it will be enough for what you're describing. But it might be.
How would I colour code the events columns and then link this between both spreadsheets?
So there is "a way" to do something like this, but it is a little involved. If are in interested in learning more about it, send me an email at info@spreadsheetlife.com.
Can you help me,?please .. , the table array in the formula cant be read :( , took a check of the spelling it matches ,,what should I do?
It might be easiest to help via email rather than in the comments. Send me an email at info@spreadsheetlife.com, attach your spreadsheet so I can look at it, and we can go from there! 😊👍
@@spreadsheetlife will do! thank you!
I’m fairly new to all the functions, but is there a way to make repeating events? Say a birthday each year?
For this particular build, there really isn't an easy way to implement this. It's certainly possible, but it would take a good amount of extra work unfortunately.
@@spreadsheetlife I was thinking I could just change the year on the birthdates for one… thanks for responding.
Gotcha. I'm sorry the solution isn't as straightforward. I still hope you enjoy the template though.
@@spreadsheetlife I’ve learned a LOT. Thank you for sharing your knowledge.
Of course! Thank you for watching! 😊
hi i am having trouble getting multiple events to show? how would i do that
Have you completed the tutorial all the way through? Or are you stuck at a specific spot?
Hi
I am having trouble getting multiple events to show? What am I doing wrong?☺️
Sure! Here’s your text in English:
And when I try to highlight the dates in the months, it goes wrong. I'm unable to make the selected month appear in black.
Send me an email at info@spreadsheetlife.com. Attach your spreadsheet to the email. I will be able to help more that way. 😊👍
What if I want to enter an event that reoccurs on a monthly or even weekly basis?
Unfortunately, based on this design, you'd have to type the event in manually for each occurrence. I'm sorry that's the case.
Hello! what version of Excel are you using? I made my calendar with events on Google sheet but when I downloaded it. I was all messed up. Please help ^_^
Hi there! So this build will work with any version that is Excel 2013 or later. So it's pretty backwards compatible. However, it's not designed for Google Sheets. That's probably why you are having issues. If you'd like to create a similar calendar in Google Sheets, check out this video instead.
ruclips.net/video/bwcughyS5PQ/видео.html
@@spreadsheetlife Thanks for your response
That's amazing to hear. I'm so glad that you got it! 😄
And thank you so much for the sub! I'll do my best to keep good content coming.
@@spreadsheetlife Keep up the good work! ^_^ Do you know about coding in Google Sheets? I was afraid of spreadsheets before I felt like I didn't know how to do them, but thanks to your tutorials, I've learned a lot! I graduated as an I.T. and I'm currently learning how to code in Google Sheets hehe I just felt excited learning new things... if you do, can you please make a tutorial about it? ^_^
I will do my very best to keep it up! 😄👍
As far as coding in Google Sheets, do you mean GAS (Google Apps Script)? If so, that might be a little out of scope for what I'd like this channel to be at the moment since I don't want to the content too far out of reach from beginners and average Google Sheets users. However, it still might be something I consider a little later on. It just may be a while. But I will most definitely take your suggestion into account, and who knows, if enough people ask me about it, I just might do it sooner rather than later. 😄
I tried on Google Sheet, but the event I created doesn't appear on the calendar. Is the formula used in Google Sheets different? Please help me
So this build was specifically designed for Excel. There is a way to design it a little differently for Google Sheets though. The best way I can help is for you to send me an email at info@spreadsheetlife.com with a link to you spreadsheet. Then I can take a look at it and will be better able to help.
@@spreadsheetlife Thank you. I have sent an email yesterday and it has been answered and helped too. Thank you very much ryannn ❤️
Of course! I'm happy to help! 😊👍
@@kyhyuHi! I also tried to do it in google sheet. Can you tell me what the formula should look like there, if you have already been helped?
Hey there! You are also welcome to send me an email at info@spreadsheetlife.com, and I can try to help! 😊👍
Using office 16 ...Events not upload in calender 😞. ..... Can u helpp ?
I'd love to help. It may be easiest to help via email rather than in the comments depending on the issue. I encourage you to send me an email at info@spreadsheetlife.com, and we can go from there! 😊👍
where does "2" come from?
Are you asking about the 2 in the VLOOKUP function? This causes the VLOOKUP function to return the value from the second column in the Events table.
i dont know what happen but my events doesnt connect in the calendar😢😢😢
Did you change the table name of the table on the Events worksheet to 'Events'? This might be the issue.
If that doesn't solve it, you can always send me an email at info@spreadsheetlife.com. Attach your spreadsheet, and I can take a look at it for you. 👍
how would i colour code specific types of events
I do have a way you can color code specific types of events, but it is a little tedious. Send me an email at info@spreadsheetlife.com, and I can show you how to do it.
Please i also need that colour code specific types of events. Plz help me. Very urgent.
Send me an email at info@spreadsheetlife.com, and I will do my best to help.
hello i got a problems with fx vlookup problems (#name? ) can u help plz
I'd love to help! Could you paste your formula here in the comments so I can take a look at if for you?
@@spreadsheetlife HELLO I GOT IT THANK YOU
BUT TELL ME IF WE CAN ADD Public HOLIDAY IN IT
Yes you can. Just add each holiday as an event. Unfortunately, there is no easy way to automate this though. You will have to type in the holiday's manually.
@@spreadsheetlife THANK YOU
You're welcome! 😊👍
WHY DID MINE BECOME ERROR WHEN IT COMES TO THE LAST PART FORMULA? CAN SOMEONE HELP ME
Did you change the table name to "Events"? That might be the issue.
Another issue may be your version of Excel. If you are using an older version of Excel, replace the IFNA function with the IFERROR function. I hope this helps.
My version is 2010
Oh ok. Then my advice is to get rid of the IFNA function entirely. Even the IFERROR function is not compatible with Excel 2010 I don't think. I'm sorry that is the case.
If I make this all and the last step the ...=IFNA(IF(VLOOKUP(B7, EVENTS,2,FALSE)=0,"",VLOOKUP(B7,EVENTS,2,FALSE)),"") GIVE ME # NAME? ..... WHERE'S the mistake how can I know it
Are you working with an older version of Excel? This may be why you are getting the error.
Try switching the IFNA function with the IFERROR function.
@@spreadsheetlife still not solve this problem....please help me
Try sending me a copy of your spreadsheet at info@spreadsheetlife.com. This way, I can take a quick look at it.
I keep getting a name error
The #NAME? error shows up when Excel does not recognize the text in a formula. This is usually due to a misspelled function. So try to make sure that you have all of the function names spelled correctly.
It could also be that you are using an older version of Excel that does not have the IFNA function. If that's the case, try using the IFERROR function instead.
Hello. Help me please
What can I help you with?
Using Excel for Mac and getting NAME error on IFNA formula. Can you help?
Yes. Try replacing the IFNA function with the IFERROR function. Let me know if this works for you!
@@spreadsheetlife Very good! Thanks. It worked.
Yay!! I'm glad it worked! 😄