List All Birthdays and Anniversaries in Calendar Months From Events Sheet

Hello,

I would like the Calendar months 1-12 to have the Birthdays and Anniversaries listed from the Events sheet with the day they occur in the bottom yellow area of the Calendars.

For instance in March month (3):

Ken's Birthday is on the 26th
Fred's Birthday is on the 28th
Karl's Birthday is on the 28th

Does anyone know formulas to do this please and also highlight the day of the month that these occur?

I manually entered them in March and highlighted the days they occur.

Thank you so much for your help

Please try at J35

Formula:

Please Login or Register  to view this content.

For highlighted
CF formula applies to =$B$4:$O$39

=COUNTIFS(Events!$I$54:$I$63,DAY(B4),Events!$H$54:$H$63,MONTH(B4))

Thanks but it isn't getting the Wedding Anniversary on May 9 or Jessica's Birthday in September

Please change to $C$2

Formula:

Please Login or Register  to view this content.