If, Networkdays, IfError

AJudge

Hello everyone

I’m in need of some more help with the below formula:

=IFERROR(NETWORKDAYS(SupQARevCompleteDate@row, PlannerRevCompleteDate@row), "N/A")

I need to add a condition to first check if Supplier QA Review Result = “Skip” then use EngRevCompleteDate@row instead of SupQARevCompleteDate@row. If Supplier QA Review Result= “Approved” then leave the rest of the formula as-is.

Any suggestions welcome.

Paul Newcome

You would use an IF statement to output the desired date and then drop that into the applicable portion of the NETWORKDAYS function.

=IFERROR(NETWORKDAYS(IF([Supplier QA Result]@row = "Skip", EngRevCompleteDate@row, SupQARevCompleteDate@row), PlannerRevCompleteDate@row), "N/A")

AJudge

This worked perfectly! You have saved me so much time, I greatly appreciate you!

April

Paul Newcome

Happy to help. 👍️