How to Make an Event Calendar in Excel - Part 1

Подписаться 6 тыс.

Просмотров 3,9 тыс.

50% 1

Learn how to build an event calendar in Excel. You can store up to five events per day, and more than one million events in total. Plus, the calendar updates automatically based on your month and year selections.
This is part one of two.
PART TWO
• How to Make an Event C...
FINAL SPREADSHEET
spreadsheetlife.com/templates...
COURSES
spreadsheetlife.com/all-courses/
OTHER
Templates: spreadsheetlife.com/templates/
Blog: spreadsheetlife.com/blog/
Music by Epidemic Sound

Опубликовано:

12 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 26

@albertvannikerk6665 9 дней назад

That is exactly what I was looking for. Thanks a million.

@spreadsheetlife 7 дней назад

Awesome!! Super glad to hear it! Thanks for letting me know. 😄

@dauntlessarte6190 Месяц назад

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

@spreadsheetlife Месяц назад

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

@terrymartin979 25 дней назад

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

@spreadsheetlife 24 дня назад

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

@QeysLucky Месяц назад

Excellent teacher

@spreadsheetlife Месяц назад

😊👍

@renatokoller1326 17 часов назад

Hi Ryan, thank you for such a great video! Unfortunately the formula =DATE(C3,MATCH...) doesn't work in my excel. Do you have any solution for that? Thank you very much in advance!

@spreadsheetlife 15 часов назад

Where are you located? If you reside in a country that uses a comma as the decimal separator for numbers rather than a period, then your Excel formula syntax may use semi-colons instead of commas as the argument separator. So try using semi-colons instead of commas. That might be the issue.

@NajK-83 20 дней назад

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

@spreadsheetlife 19 дней назад

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

@terrymartin979 25 дней назад

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 21 день назад

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.

@Bjorg20 15 дней назад

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 14 дней назад

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 14 дней назад

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

@spreadsheetlife 13 дней назад

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

@Bjorg20 12 дней назад

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 RU-vid 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. 👩🏻‍💻

@spreadsheetlife 10 дней назад

You just made my day. Thank you so much for your kind and heartfelt words. They mean so much to me and really encourage me to keep going and give it my all to create the best content I can. 😊