Days in progress formula with multiple criteria

kaylynn.mcclain60041

Hello,

is it possible to run a formula that gets me the following? 

If the status is “Not started” or “in progress” then count the number of business days between “date presented” and today, and if the status is “complete” then Count the number of business days between “date presented” and “date completed”

J. Craig Williams

Here's one way to do it:

=IFERROR(NETWORKDAYS([Date Presented]@row, IF(OR(Status@row = "Not Started", Status@row = "In Progress"), TODAY(), IF(Status@row = "Complete", [Date Completed]@row, "status unknown"))), "date missing")

This will return "status unknown" if there are other Status values found and "date missing" if there is a needed date not found.

Craig