Totaling # the of projects that are older than 30 days, 365 days etc

Goal: how many open requests are older than the specified # of days old, this formula returns a result, just don't think it is the correct one as when I try to duplicate it and ask for requests more than a year old, the number encompasses ALL open projects in the last 365 days not the ones specifically older than a year:

=COUNTIFS({OPENED}, >=TODAY(-30), {CLOSED}, ISBLANK(@cell))

=COUNTIFS({OPENED}, >=TODAY(-365), {CLOSED}, ISBLANK(@cell))

Find more posts tagged with

Formulas

Accepted answers

Gia Thinh

Hi MichelleR,

A little bit changing for the operators as below. Try it!

=COUNTIFS({OPENED}, <TODAY(-30), {CLOSED}, ISBLANK(@cell))

=COUNTIFS({OPENED}, <TODAY(-365), {CLOSED}, ISBLANK(@cell))

All comments

Gia Thinh

Hi MichelleR,

A little bit changing for the operators as below. Try it!

=COUNTIFS({OPENED}, <TODAY(-30), {CLOSED}, ISBLANK(@cell))

=COUNTIFS({OPENED}, <TODAY(-365), {CLOSED}, ISBLANK(@cell))

MichelleR

@Gia Thinh yes that works!

Follow up question, is there a way to specify a range of days from today's date, example things created between 30-60 days ago, instead of all created in the last 60 days, for example?

MichelleR

@Gia Thinh nevermind to my second question, figured it out, thanks!

Gia Thinh

Happy to 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.