I made a calendar shown below, monthly view. The picture is resized to fit this blog, click to see the original size. This calendar is more advanced than the template I made year 2011.
The form next to the calendar allows you to add events. Enter time and event name and then click button "Add".
See all events on a specific date
If there are more events on a single day than can be displayed, the last line tells you ...more.... See picture below for an example.
Select that cell and all events are shown in a table next to the calendar.
You can easily edit or delete an event by clicking a link in column Time, see picture above. The link takes you to the record on sheet "Schedule", see picture below.
Here you can edit or delete the record as you please.
The buttons above the calendar lets you go to next or previous month, there is also a button that takes you to the current month, button "Today"
Days before and after selected month are grayed out. Current day is highlighted orange. The following picture shows you this.
The best I could do is creating a formula that calculates the upcoming recurring event. Events after that are not shown until the date has passed.
Array formula in cell H4:
Array formula in cell H5:
Anyone got a better idea?
Download excel *.xlsm file
This workbook contains macros and a custom function.