View Single Post
  #2   Report Post  
xgirl
 
Posts: n/a
Default

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