Originally Posted by ArviLaanemets

In attached file is a possible solution.

NB! It's better to leave the Weekday() function with European format - much easier for calculations when weekends are days 6 and 7.

PS. Without additional sheet it will be nearly impossible. You must move the date away from weekend, then move away from holiday when date happens to be one, then again you have to check that new dates aren't weekends and when , then move the date, then you have anew to check for holidays, etc.