Adjusting formula to calculate weekdays only

[greeneggsandsam]

I have the following formula....
=IF(B6<1,"",IF(I6<1,"PENDING",IF(J6>0,J6-I6,"PENDING")))
Where B6 = Job Number
Where I6 = Date Received
Where J6 = Date Completed
This calculates calendar days but now I need it to calculate only business days.
Not sure where within this equation I should insert the NETWORKDAYS function

[AL1976]

=IF(B6<1,"",IF(I6<1,"PENDING",IF(J6>0,NETWORKDAYS(I6,J6),"PENDING")))

does this work ?

[Kaper]

Have you tried:
=IF(B6<1,"",IF(I6<1,"PENDING",IF(J6>0,NETWORKDAYS(I6,J6),"PENDING")))

or (if done one day = 0)
=IF(B6<1,"",IF(I6<1,"PENDING",IF(J6>0,NETWORKDAYS(I6,J6)-1,"PENDING")))

[greeneggsandsam]

That worked perfectly.
Now I have to do the same for formulas where multiple dates are considered. (Below...)
Formula 1
=IF(B5<1,"",IF(H5<1,"PENDING",IF(P5>0,(P5-N5)+(M5-K5)+(J5-H5),"PENDING")))

Formula 2
=IF(B5<1,"",IF(M5<1,"PENDING",IF(N5>0,N5-M5,"PENDING")))

B5=Job Number
H5=Date Submitted to Dept. #1
J5=Date Received by Dept. #2
K5=Date Completed by Dept. #2
M5=Date Received by Dept. #3
N5=Date Completed by Dept. #3
P5=Date Completed by Dept. #1

I keep getting too few arguments

[Kaper]

Formula 2
=IF(B5<1,"",IF(M5<1,"PENDING",IF(N5>0,N5-M5,"PENDING")))
can be changed into one using networkdays exactly as above
=IF(B6<1,"",IF(I6<1,"PENDING",IF(J6>0,J6-I6,"PENDING")))
into
=IF(B6<1,"",IF(I6<1,"PENDING",IF(J6>0,NETWORKDAYS(I6,J6)-1,"PENDING")))

But as it is excatly the same problem - I leave it to you as a "homework".

As first one is considered - - the "frame" can be the same
=IF(B5<1,"",IF(H5<1,"PENDING",IF(P5>0,(P5-N5)+(M5-K5)+(J5-H5),"PENDING")))
The only part which tequires changing is the inner one:
(P5-N5) + (M5-K5) + (J5-H5)
you have sum of three parts here.
So in final formula there will be sum of 3 NETWORKDAYS formulas

NETWORKDAYS(N5,P5)+NETWORKDAYS(K5,M5)+NETWORKDAYS (H5,J5)-3
(this -3 is necessary, if we count part started and finished the same day as 0)

Enjoy!

Kaper