How do you count work days excluding weekends and holidays?
 

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.

Use the NETWORKDAYS worksheet function.

HTH
Jason
Atlanta, GA

-----Original 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.
.

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.