This workbook contains two worksheets, one worksheet shows a calendar and the other worksheet is used to store events. The calendar sheet allows you to enter a year and use a drop down list to select a month.
A small VBA event code tracks which cell you have selected and shows the corresponding events accordingly.
How this workbook works
The animated image above shows how to enter data and how to select a given date. Today's date is highlighted yellow, days with one or more events are also highlighted, in this example blue.
Excel extracts data dynamically meaning the named range grows automatically when new data is entered, we don't need to change the formula cell references.
'Event code that is executed every time a cell is selected in worksheet Calendar
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Check if selected cell address is in cell range B5:H10
If Not Intersect(Target, Range("B5:H10")) Is Nothing Then
'Save date to cell G2
Range("G2") = Target.Value
Paste to worksheet module.
Note, save your workbook with file extension *.xlsm in order to attach the code to the workbook.