Formula for calculating MOST RECENT & OLDEST in Business Days

Part 1)

How old is the most recent request? I have done this one before, but cannot remember what I am missing.

=MAX([Date Submitted]:[Date Submitted])

Part 2)

I have the formula, but want it to calculate in business days. I'm sure this is something simple I am overlooking.

=TODAY() - MAX(COLLECT([Date Submitted]:[Date Submitted], Status:Status, OR(@cell <> "New Request", @cell <> "Reviewing Request")))

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you trying to calculate the number of days for #1?

For #2: Try a NETWORKDAYS function.

=NETWORKDAYS(start_date, end_date)

MeganJF

For part 1, Want to calculate how old the most recent request is.

Paul Newcome

In that case you would use the same NETWORKDAYS function as in #2.

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.