default days

A

Avudaiyappan

On excel 2003 i am using networkdays function on that the default was set to
5 days now i want to change it to 6 days. How do i proceed
 
B

Bob Phillips

Do you mean 6 working days in a week? If so, try

=SUMPRODUCT(INT((MAX(end_date,start_date)-WEEKDAY(MAX(end_date,start_date)+1
-{2;3;4;5;6;7})-MIN(end_date,start_date)+8)/7))
-SUMPRODUCT(ISNUMBER(MATCH(WEEKDAY(holidays),{2;3;4;5;6;7},0))*(holidays>=MI
N(end_date,start_date))*(holidays<=MAX(end_date,start_date)))

This assume Mon-Sat, so just change the array 2;3;4;5;6;7 to 1;2;3;4;5;6 if
you want Sun-Fri.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top