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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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