Formula Suggestion

Zedrick13 · Sep 19, 2018

How do I refine this formula below.

Code:

=IF(ISBLANK(A2),"",IF(ISBLANK(C2),"",IF(A2<>"",NETWORKDAYS(A2,C2),IF(C2<>"",NETWORKDAYS(A2,C2)))))

Is it possible to combine the first and second if arguments and the 3rd and 4th if argument?

Michael M · Sep 19, 2018

Maybe this

Code:

=IF(OR(ISBLANK(A2),ISBLANK(C2)),"",IF(OR(A2<>"",C2<>""),NETWORKDAYS(A2,C2)))

Michael M · Sep 19, 2018

Better

Code:

=IF(OR(ISBLANK(A2),ISBLANK(C2)),"",NETWORKDAYS(A2,C2))

Aladin Akyurek · Sep 19, 2018

Looks like you want:

=IF(COUNT(A2,C2)=2,NETWORKDAYS(A2,C2),"")