It needs to be in brackets...
=NETWORKDAYS(B2,C2,"1/1/05",{"1/17/05","1/18/05"})
"Lamar" wrote:
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
|