NetWorkDays Function Syntax

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

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

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)

"xgirl" wrote:

> 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