Formula to add days with holiday & weekend

Hello,

I am looking for a formula to add days if there is (are) holiday between the pay date. We currently get pay 2 times in a month. Normally we take 15 workdays to process the payroll. If there is(are) holiday(s), the payroll process date will be extend for the number of day of the holiday. I am attaching a sample file here.

Thanks for the help.