To answer your question we would need to know how your data are arranged but in general this is what you might do ....
You would need to set up a table with each holiday's date e.g.
Col AA Col AB
1 Holiday x Date
2 Holiday y Date
3 Holiday z Date
Then in a column next to each date you want to evaluate you can have a formula like this
(assuming your dates are in Column F starting in row 1
Give this a try or if I've misunderstood please come back with more details.