Formal to Count for Past Year

tashacrop

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)

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.