Difference in Days Excluding Saturday and Public Holiday

Hi Kumara_faith,

Find the attached which will do what you want (I hope). The new work is below the first try.
I had to convert your Holiday List to Month/Day/Year format as you gave them in Day/Month/Year.
The method was to do a =Countifs formula to count all holidays after the start date AND before the end date.

I hope this works for you. There may be some problems if a person starts and ends on the same day or works less than a week. Please test my formula.