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