I'd do it like the attached, with some less complex formulas.
For reference, in order to use the VLOOKUP formulas, I had to sort your data into ascending order of dates.
I also added another sheet that has a calculation of the holidays and the previous work days.
Bookmarks