NETWORKDAYS Function

[Steve F]

Hope someone can help:

I am attmpting to use the NETWORKDAYS function in large
spreadsheet. The general format of the function is:

=NETWORDAYS(StartDate, EndDate, {Holidays})
such as:
=NETWORKDAYS("1/1/2004","12/31/2004",
{"01/01/2004","05/31/2004","07/04/2004","09/06/2004","11/2
5/2004","11/26/2004","12/23/2004","12/24/2004","01/03/2005
"})

Because this fomula is copied in about 80 different
cells, and the start date and end date can be dynamic
referenced to other cells my formula ends up as:
=NETWORKDAYS(F1,G2,
{"01/01/2004","05/31/2004","07/04/2004","09/06/2004","11/2
5/2004","11/26/2004","12/23/2004","12/24/2004","01/03/2005
"})

What I can not figure out is how to get the array portion
to refence a cell. It would be great if this list could
be dynamically updated from one cell, but I am constantly
getting format errors.

Any help would be appreciated.

 

[Peo Sjoblom]

Put all the holiday dates in a range, let's say H1:H11, select the range,
while still selected click in the name box (the little box that tells which
cell(s) is selected
above the row headers) and type Holidays, now in your formula use

=NETWORDAYS(StartDate,EndDate,Holidays)

 

[Steve F]

Thank You Peo - that works great - really appreciate the
help.