IFS with a Network Days Sum

[stuhendry]

Hi guys,

I'm attempting to get a formula to return the age of when a file was submitted (business days) but there's multiple conditions to be met/excluded to allow the sum to function.

Condition 1 = Survey Pack Returned (date field) - column A
Condition 2 = Pack Submitted for Approval (date field) - column B
Condition 3 = Approval Received (date field) - Column C

The following formula works =IF(C2>=1,"",NETWORKDAYS(B2,$I$1)) providing the pack has been returned and has been submitted but if no pack has been returned, I want the field to remain blank - only calculating network days of Packs submitted but not yet approved. I've attached a workbook to simplify the details.

Many thanks in advance
Stuart

[JohnTopley]

In D2

=IF(AND(A2>0,B2>0,C2=""),NETWORKDAYS(B2,$I$1),"")

[stuhendry]

In D2

=IF(AND(A2>0,B2>0,C2=""),NETWORKDAYS(B2,$I$1),"")

Thanks John, appreciated!