What is the correct COUNTIFS/TODAY formula for past and future 90 days?

I am trying to COUNT the tasks assigned to departments in the past/future 90 days. I am using sheet summary fields for this data.

These are the formulas I have come up with but they are not accurate.

=COUNTIFS(Department1:Department72, "fsb", [Start Date]1:[Start Date]72, <=TODAY(-90))

=COUNTIFS(Department1:Department72, "fsb", [Start Date]1:[Start Date]72, <=TODAY(+90))

Where have I gone wrong?

2022-07-06_8-19-13.png

2022-07-06_8-22-47.png

Find more posts tagged with

Formulas

Accepted answers

All comments

Jake Gustafson

Try something like this:

=COUNTIFS(Department:Department, "FSB", [Start Date]:[Start Date], AND(@cell >= TODAY(-90), @cell <= TODAY()))

=COUNTIFS(Department:Department, "FSB", [Start Date]:[Start Date], AND(@cell <= TODAY(90), @cell >= TODAY()))

Aimee Eckert

Thank you very much Jake! You rock!

Jake Gustafson

Glad it 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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.