Counting work days

[Guest]

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

 

[Fredrik Wahlgren]

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

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

/Fredrik