Create an Appointment Calendar in Google Sheets | Part 2

Learn how to build a dynamic appointment calendar where you can enter events and update the calendar automatically simply by changing the month or the year.
PART ONE
• How to Create a Dynami...
START FILE
spreadsheetlife.myflodesk.com...
COURSES
spreadsheetlife.com/all-courses/
OTHER
Templates: spreadsheetlife.com/templates/
Blog: spreadsheetlife.com/blog/
VIDEO CHAPTERS
00:00 - Intro
00:50 - Event List
03:20 - The Formula
05:19 - Two Important Points

[@spreadsheetlife]

You can find part one here: czcams.com/video/bwcughyS5PQ/video.html

[@Greg.Contreras]

Tolly useful!

[@spreadsheetlife]

😄👍

[@graemehill3709]

Thanks man. This channel is 🔥

[@spreadsheetlife]

Thanks so much! I'll do my best to keep it up! 😎

[@s.zulaikha4259]

hi, i wonder if you could make tutorial for this calendar as a business version? such as resort bookings. currently im running small resorts and usually i wrote down names in each columns

[@spreadsheetlife]

That sounds like a fascinating take on the calendar. I'd love to see what I could possibly put together for you.
Would you be willing to send me an email at [e-mail] with more details on how you would like it to work?

[@joeycarino516]

How about when you change the year? The event will no longer visible when u change it

[@spreadsheetlife]

When you change the year, it will update all the dates as well. Since the calendar is designed to show events that appear on specific dates, everything will be updates accordingly. So if you have an event set on June 8, 2024, but you change the year to 2023, the event will not show up on June 8, 2023. The year would have to be 2024. I hope this all makes sense. Let me know if you have any other questions.

[@user-cv3mw5gx2p]

My notes still copies to the following months :( .. pls help.

[@spreadsheetlife]

How strange. Are you storing your events in the Events tab? Or are you typing them directly into the calendar? The events must be stored in the Events tab only. I hope this helps.