Count # of networkdays if a condition is not met

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! :-)

Find more posts tagged with

networkdays

Accepted answers

BullandKhmer

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

All comments

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!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.