SUMIF row is in the next 5 working days

Hello,

I am trying to create a formula that counts the total size (EQA) of the jobs that are due in the next 5 working days.

I am using this formula but it's coming up with 0

=SUMIFS(EQA:EQA, [Delivery Date]:[Delivery Date], ISDATE(1), [Delivery Date]:[Delivery Date], NETWORKDAYS(TODAY(), TODAY(7), 0))

countif.png

Any help on this would be greatly appreciated because I need to do a few of these calculations.

Find more posts tagged with

Formulas

Accepted answers

Genevieve P.

Hi @Neville

Your criteria for this will be two things:

Greater than or equal to Today
Less than or equal to 5 Working Days from now

This means that for your second criteria, instead of using the NETWORKDAYS function to find a number, you actually want to use the WORKDAY Function to find a date, like so:

WORKDAY(TODAY(), 5)

This looks for 5 working days from Today's date.

Try this formula instead:

=SUMIFS(EQA:EQA, [Delivery Date]:[Delivery Date], @cell >=TODAY(), [Delivery Date]:[Delivery Date], @cell <= WORKDAY(TODAY(), 5))

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Neville

Your criteria for this will be two things:

Greater than or equal to Today
Less than or equal to 5 Working Days from now

This means that for your second criteria, instead of using the NETWORKDAYS function to find a number, you actually want to use the WORKDAY Function to find a date, like so:

WORKDAY(TODAY(), 5)

This looks for 5 working days from Today's date.

Try this formula instead:

=SUMIFS(EQA:EQA, [Delivery Date]:[Delivery Date], @cell >=TODAY(), [Delivery Date]:[Delivery Date], @cell <= WORKDAY(TODAY(), 5))

Cheers,

Genevieve

Neville

Hi @Genevieve P. ,

Thank you so much, you didn't just answer my question you actually helped me understand this so much better!.

Very much appreciated.

Thanks :)

Neville

Genevieve P.

No problem at all! I'm glad I could help. 🙂

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.