Formal to Count for Past Year

I'm stuck trying to get a look back count of requests in the past year. For some reason the formula is coming back with 39 instead of the actual 32. Any ideas?

Any help to also exclude the current month would be great!

=IFERROR(COUNTIFS({Legal Pending Requests Range 1}, IFERROR(MONTH(@cell), 0) <= MONTH(TODAY(-365)), {Legal Pending Requests Range 2}, [Matter Type]@row, {Legal Pending Requests Range 3}, JL@row, {Legal Pending Requests Range 4}, <>"Completed"), 0)

Find more posts tagged with

Formulas

Accepted answers

All comments

Jason Albrecht

Hi @tashacrop ,

I had a similar situation when using the Prorata function and found that, depending on the other conditions, I had to use either -365.25 or -366, to help account for leap years as well.

I don't know if this would work in your situation... just thought I'd mention it.

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.