How do you count work days excluding weekends and holidays?

G

Guest

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

Chip Pearson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date + X days excluding holidays 1
Count days between two dates excluding weekends 1
vacation excluding holidays 1
Counting work days 1
How to calculate the number of days between two dates 2
Date Calculation Formula- Calendar days minus Holidays 1
Diff in business days 2
TODAY, Subtract a List of Dates from... 2

Top