Hi helpful community,

I have lost days and gained grey hair in an effort to overcome what i am sure is a simple excel challenege; please help!

My challenge:

Cell J12 is a fixed date (1/1/13)
Cell L13:L112 contains blank cells and various dates
I need Cell J14 to return specific text (in my case "CRM Event") if cell J12 (the date) matches any of the dates in cell L13:L112

Can you help?