NetWorkDays Function Syntax

L

Lamar

What is the syntax to add more than one "holiday" for NetWorkDays function?
The below formula does not work:
=NETWORKDAYS(B2,C2,"1/1/05","1/17/05")

Do you have reference other cells with the dates that are suppose to be
excluded? Or can you manually enter dates into the function? Thank you
 
K

Kassie

Hi Lamar

Insert a list of public holiday dates, say in F1:F13 or whatever.
Your formula should then read =NETWORKDAYS(B2,C2,F1:F13)
 
Top