SUMIFS with Working Days

Hello,

I have the following formula that works but I want to adjust it to working days only:

=SUMIFS({Column1}, {Date}, <TODAY(), {Date}, >TODAY(-90), {DE}, ([Column2]@row))

Is there a way to modify this formula to include only working days? I think that the sheet is counting weekends at this moment. I updated the properties of the sheet to specify Mon-Fri, but not sure how to implement "WORKDAY" into the formula. Can you please advise?

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Do you mean to pull in only the working days from {Date}? If so, try this:

=SUMIFS({Column1}, {Date}, AND(@cell <TODAY(), @cell>TODAY(-90), IFERROR(WEEKDAY(@cell), 0)>= 2, IFERROR(WEEKDAY(@cell), 8)<= 6), {DE}, [Column2]@row)

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.