Home |
Search |
Today's Posts |
#1
|
|||
|
|||
MS Excel Function - Networkdays
Dear Sir,
We are trying to workout with networkdays function uses in Excel. but it is taking the 5 days a week ( 2 holiday in week). but my requirement is 6 days a week. I have gone throught the documents available on net. the still unable to find the default holiday used by the networkdays function. & how to work out with this. Please find the formula which I am using. Kindly help me in this matter. =IF(AND(INT(StartDT)=INT(EndDT),NOT(ISNA(MATCH(INT (StartDT),HolidayList,0)))),0,ABS(IF(INT(StartDT)= INT(EndDT),ROUND(24*(EndDT-StartDT),2),(24*(DayEnd-DayStart)*(MAX(NETWORKDAYS(StartDT+1,EndDT-1,HolidayList),0)+INT(24*(((EndDT-INT(EndDT))-(StartDT-INT(StartDT)))+(DayEnd-DayStart))/(24*(DayEnd-DayStart))))+MOD(ROUND(((24*(EndDT-INT(EndDT)))-24*DayStart)+(24*DayEnd-(24*(StartDT-INT(StartDT)))),2),ROUND((24*(DayEnd-DayStart)),2)))))) Thanks & Regards |
#2
|
|||
|
|||
See if my contribution here helps... http://www.mrexcel.com/board2/viewto...724&highlight= Nilesh Inamdar Wrote: Dear Sir, We are trying to workout with networkdays function uses in Excel. but it is taking the 5 days a week ( 2 holiday in week). but my requirement is 6 days a week. I have gone throught the documents available on net. the still unable to find the default holiday used by the networkdays function. & how to work out with this. Please find the formula which I am using. Kindly help me in this matter. =IF(AND(INT(StartDT)=INT(EndDT),NOT(ISNA(MATCH(INT (StartDT),HolidayList,0)))),0,ABS(IF(INT(StartDT)= INT(EndDT),ROUND(24*(EndDT-StartDT),2),(24*(DayEnd-DayStart)*(MAX(NETWORKDAYS(StartDT+1,EndDT-1,HolidayList),0)+INT(24*(((EndDT-INT(EndDT))-(StartDT-INT(StartDT)))+(DayEnd-DayStart))/(24*(DayEnd-DayStart))))+MOD(ROUND(((24*(EndDT-INT(EndDT)))-24*DayStart)+(24*DayEnd-(24*(StartDT-INT(StartDT)))),2),ROUND((24*(DayEnd-DayStart)),2)))))) Thanks & Regards -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=320571 |
#4
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |