I was wondering if anyone can help me: I've been trying to figure out how I
can get Excel to calculate the number of weekdays between two dates (in a
similar method to NETWORKDAYS) but to also include any public holidays (as
they're not included in our holiday allowance). Does anyone know of a way of
doing this? It seems a pain to find a list of the public holidays for the
coming year and then entering them into a list that needs to be updated.

Thanks in advance.

--
Regards,

-Andrew Perry (Network & Servers Officer),
Computer Office, Trinity College, Cambridge
University.