Good Morning All,

I have created a calendar that has a full year as well as each month. I believe I have everything setup correctly so each year when I need to update the calendar I just have to change the year and the list of blackout dates and birthdays. My question is when I'm in the month view if a blackout date or birthday falls in the previous or next month either a few days before or few days after it is still showing. I don't want it to show unless its part of that month.

I have attached my file for assistance. The first occurrence is in May where Joe Apple's Birthday is June 6th so it is showing in May as it is part of that monthly view but I have the conditional formatting turn the date if its not associated with that month to White with White font.

Annual Calendar.xlsx