Hi, your videos are very helpful! Btw, I just want to know if what will be the formula if we are going to add another tab aside from events and date? I tried adding another range into the formula, but unfortunately it doesn't Work. We would want to have two details that will appear in every date. Example Event + Name I hope you will notice this. Thank you and God bless!
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
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 info@spreadsheetlife.com with more details on how you would like it to work?
Yes. One way you can do this is by applying a conditional formatting rule to the calendar cells where you set format cells if to "Text That Contains." I hope this helps.
Hi there! So far, I've made four different videos on calendar builds in Excel and Google Sheets, so I may not get to another event/calendar style tutorial in a while. Especially with so many other videos in my queue. But if you'd like some guidance, you can always email me at info@spreadsheetlife.com.
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.
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.