Counting work days

H

Hausma

This wI want to count the number of work days between two dates. Do I have
to rewrite the formula for each row or can I tell it to compare the date in
column a to the date in column b and count the workdays and exclude holidays.
The worksheet has over 1,000 rows. Example:

1/4/05 1/4/05
1/5/05 1/11/05
2/6/05 3/15/05
 
F

Fredrik Wahlgren

Hausma said:
This wI want to count the number of work days between two dates. Do I have
to rewrite the formula for each row or can I tell it to compare the date in
column a to the date in column b and count the workdays and exclude holidays.
The worksheet has over 1,000 rows. Example:

1/4/05 1/4/05
1/5/05 1/11/05
2/6/05 3/15/05
Click to expand...

I think the NETWORKDAYS function is what you need
http://support.microsoft.com/?kbid=259200

/Fredrik
 
Top