Counting weekdays between two dates

[DocDeb]

I am currently counting days between J2 and K2, but I want to count only Monday-Friday.
• =IFERROR(IF(J2="","",IF(K2="","",DATEDIF(J2,K2,"d"))),"")
J2=Date Last Deliverable Received, K2=Date Completed
So if J2 is Friday and K2 is Monday, it would only be 1 day.
I thought of using NETWORKDAYS function or WEEKDAY function but can't figure it out in my current formula.

 

[Joe4]

Try:

=IFERROR(IF(J2="","",IF(K2="","",NETWORKDAYS(J2,K2))),"")

or more simply:

=IFERROR(IF(OR(J2="",K2=""),"",NETWORKDAYS(J2,K2)),"")