Add date to formula

Hi I am currently using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist") I want to look at the date for the next 30 days. I have a column titled "Due Date" with dates (2/20/2021) in them. I want the total number of slides in the next 30 days. Could you please help me with this. Thanks

Find more posts tagged with

Integrations

Automations

IT & Operations

Conditional Formatting

Project Management

Accepted answers

Kelly Moore

Try this

=SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist", [Due Date]:[Due Date], AND(TODAY() <= @cell, @cell <= TODAY(30)))

Please ensure that your Due Date column is formatted as a Date column

cheers,

All comments

Kelly Moore

Try this

=SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist", [Due Date]:[Due Date], AND(TODAY() <= @cell, @cell <= TODAY(30)))

Please ensure that your Due Date column is formatted as a Date column

cheers,

Sara Moore

Thank you that worked!

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.