Get instant live expert help on networkdays function in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
How do I explain this calculation a. =(NETWORKDAYS(C2,G2,$O$2)-1)*("17:00"-"8:00")+IF(NETWORKDAYS(G2,G2,$O$2),MEDIAN(MOD(G2,1),"17:00","8:00"),"17:00")-MEDIAN(NETWORKDAYS(C2,C2,$V$2)*MOD(C2,1),"17:00","8:00")
Solved by O. B. in 12 mins
I am trying out a formula I saw in google but its not working in my excel and producing an error. Can you please help me? =(NETWORKDAYS(StartDT,EndDT)-1)*(StopTime-StartTime)+IF(NETWORKDAYS(EndDT,EndDT),MEDIAN(MOD(EndDT,1),StopTime,StartTime),StopTime)-MEDIAN(NETWORKDAYS(StartDT,StartDT)*MOD(StartDT,1),StopTime,StartTime)
Solved by T. U. in 29 mins
I am using the NETWORKDAYS Function. Instead of giving me results in days, it displays a date. Example being instead of 1 day, it displays 1/1/1900
Solved by M. F. in 23 mins
I don't understand this formula from a previous colleague, its supposed to be working out holiday hours remaining, can you help? =IF(NETWORKDAYS(TODAY(),B10)<0,0,NETWORKDAYS(TODAY(),B10))
Solved by F. D. in 28 mins
Hi I need to find out what this excel formula means =(NETWORKDAYS(F2,Q2,'Change of Status'!$A$1:$A$17)-1)*("16:00"-"08:00")+IF(NETWORKDAYS(P2,P2,'Change of Status'!$A$1:$A$17),MEDIAN(MOD(P2,1),"16:00","08:00"),"16:00")-MEDIAN(NETWORKDAYS(F2,F2,'Change of Status'!$A$1:$A$17)*MOD(F2,1),"16:00","08:00") FYI the "change of status" is a tab that includes holidays for the year, Thanks
Solved by E. J. in 13 mins