Count # of networkdays if a condition is not met

Paula Cosentino

Hello,

I want a formula to count the number of workdays between when an item was assigned only if a condition is not met.

=IF(Request Status - Contracting]@row <> "Contract work Complete", [Date Assigned to CM]@row, TODAY())

I want the # of days counted since an item was assigned to a manager only if the manager has not marked the line "Contract work Complete". To make things just a bit harder, I don't want the column "Request Status - Contracting" to equal "Contract work complete" or "Contract work executed"

Thank you for any help! :-)

BullandKhmer

=IF(OR(Request Status - Contracting]@row <> "Contract work Complete",[Request Status - Contracting]@row <> "Contract work Executed"), NETWORKDAYS([Date Assigned to CM]@row, TODAY()))

BullandKhmer

=IF(OR(Request Status - Contracting]@row <> "Contract work Complete",[Request Status - Contracting]@row <> "Contract work Executed"), NETWORKDAYS([Date Assigned to CM]@row, TODAY()))

Paula Cosentino

thank you so much!!