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 |
"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 |
All times are GMT +1. The time now is 07:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com