Networkdays when doing sums

I have a working formula (below) that works well, but includes weekends in the return. I am finding a date in a range, and then adding Duration per products X #products. How do I get it to work with weekdays only?

=MAX(COLLECT(Assigned:Assigned, Priority:Priority, "HP 1")) + (MIN(COLLECT([product counts]:[product counts], [review status]:[review status], <>"Review Complete", BPM:BPM, "1", [Priority Level]:[Priority Level], "HP 1")) * [Days per Product]#)

Find more posts tagged with

Formulas

networkdays

Accepted answers

All comments

KPH

You can use the NETWORKDAY or NETWORKDAYS function:

=NETWORKDAYS(formula for the start date, formula for the end date)

Replacing the part in italics with your formulas for the start and end dates.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.