NETWORKDAYS

[Tom]

When using the NETWORKDAYS function I am asking Excel to
count the workdays in December. I can input '01 Dec 03'
in the Start_Date field and '31 Dec 03' in the End_Date
field but I can't seem to input more than one holiday (i.e
both the 25th and 26th). Can anyone suggest the
correcting wording.

Any help would be appreciated.

 

[Akshay Bakhai]

Define your holiday list in a separate isolated range of
cells (maybe on a separate sheet if you do not want to see
them mixed with your real data).

Thereafter in your networkdays formula just refer to this
range of cells and everything should work fine.

If you are planning to copy this NETWROKDAYS formula
across several cells then remember to use absolute
references in the formula for your holiday-list range of
cells (i.e. prefix the row and column names with $ sign).

 

[Ron Rosenfeld]

When using the NETWORKDAYS function I am asking Excel to
count the workdays in December. I can input '01 Dec 03'
in the Start_Date field and '31 Dec 03' in the End_Date
field but I can't seem to input more than one holiday (i.e
both the 25th and 26th). Can anyone suggest the
correcting wording.

Any help would be appreciated.

I assume you are entering the dates directly into the formula. In that case,
you should be entering the holidays as an array constant:

=networkdays("01 Dec 03","31 Dec 03",{"25 Dec 03","26 Dec 03"})

However, entering dates in this method is not a good idea. It would be better
to enter the dates in separate cells, and then refer to those cells in the
formula. In addition, from HELP for NetWorkdays:

Important Dates should be entered by using the DATE function, or as results
of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd
day of May, 2008. Problems can occur if dates are entered as text.




--ron