I'm trying to get a formula that looks up the date in that column and compares it to a list of holidays. If there's a holiday I want it to report the holiday name. If there isn't a holiday then I just want it to lookup and report the day (e.g., Monday).
I'm having a problem getting it right when the date is a holiday. For instance, 4/14/17 is a holiday (Good Friday) so I want it to report "Good Friday" but it's reporting FALSE. I think I don't have enough arguments in the formula for when it doesn't find the current date in the holiday list.
See example attached, cell P66.