How do I check, if there is a holiday between two dates?
I have two sheets: one with a 'Start' date and a 'End' date; another with a table containing a list with holiday dates.
My goal is to 'highlight' the Start and End dates with conditional formatting, if one or more holidays falls between them.
It would be handy as well to get a listing of those holidays in the cell next to it.
But that is another puzzle for me to look into.
I've looked around the net, but only seem to find formulas for checking if a specific date is between two dates.
I'm also not sure about what to look for, to solve this problem.
Bookmarks