default days
 

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

default days
 

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,st art_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)

"Avudaiyappan" wrote in message
...
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