Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I modify the default working days in excel | Excel Discussion (Misc queries) | |||
Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
Vacation Accrual Formula | Excel Worksheet Functions | |||
Setting and KEEPING the default chart | Charts and Charting in Excel | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |