Use the NETWORKDAYS function. E.g.,
=NETWORKDAYS(start_date,end_date,Holidays)
See the on line help for more information.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Hausma" wrote in message
...
I have a large spreadsheet (Excel 2000) that contains more than
1,000 rows.
There are two columns with dates and I want to count the
workdays, excluding
weekends and holidays between the dates in each row. Can I do
this without
having to put the dates from each column that I want compared
in the formula?
I want to count the workdays between whatever dates are in
these two columns.