NETWORKDAYS

  • Thread starter Thread starter Tom
  • Start date Start date
T

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.
 
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).
 
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.
Click to expand...

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
 
Back
Top