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" <[email protected]> wrote in message
news:[email protected]...
>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.