non-working holidays

Originally Posted by Miraun

It appears that you may be over complicating the situation slightly.
Rather than a separate function for the holidays, there is a pre-existing function =Workday that functions similarly. This function uses an array for the holiday values.
Rather than the imbedded dates within the VBA, I'd recommend setting those to another worksheet, and name the array of holidays (for however many years of data you have), as "Holidays"
Then using Bob Phillip's equation, you can get what you're looking for within the employee data worksheet.

OK, I'll make a separate table with a list of holidays, but would like to know how to implement a written VBA code in the formula.

Originally Posted by barkarlo

OK, I'll make a separate table with a list of holidays, but would like to know how to implement a written VBA code in the formula.

Why do you insist on that unnecessary step?