Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting work days
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 |
#2
|
|||
|
|||
"Hausma" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting days between dates | Excel Discussion (Misc queries) | |||
Counting days | Excel Worksheet Functions | |||
Adding Work Days only in a function? | Excel Worksheet Functions | |||
Counting days worked | Excel Worksheet Functions | |||
Counting days and Configurations together | Excel Worksheet Functions |