Simple Dynamic Calendar Questions

[lily.lily]

Hi, I have made a dynamic calendar. I don't know too much about excel so I followed a video to create it. I have exported my calendar from my calendar on the computer, and just type down the date and the event name.
Because of possible constant changes, and multiple events, I really don't want to have to type any events by hand. So this would work perfect for me..
But I have come to face two questions. I have attached my calendar in the attachment.
I hope someone can help me with them.

1. I have events I want to have it reoccurring every month, but I don't know how to enter it.
2. I have two calendars one personal and one is holiday. I don't have them enter in the same value, but I couldn't find a way for it to pull in one cell.

Calendar Main (1).xlsx

I would greatly appreciate anyone's help. Thank you.

[Pete_UK]

As your calendar is only set up to display a single month, which can be changed in cell A1, then in the situation where you have monthly recurring events (like your third example) you could enter the date for these as a formula where the month is picked up from the month in A1 of the Calendar sheet.

To cope with multiple events on the same day you can have multiple rows for each week (say up to 5, to cope with up to 5 simultaneous events) under each date row, or you could concatenate the events for each day, separated by a line-feed character. You could arrange it so that any holidays will appear always on the top row immediately under the date, and any other event would appear in the rows below.

Hope this helps.

Pete

[lily.lily]

Hi Pete, thank you for your suggestions. Do you have recommendations on how to create the formula for them? I am still learning and would appreciate the help. Thank you.