Formal to Count for Past Year

Options

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)

Tags:

Answers

  • Jason Albrecht
    Jason Albrecht ✭✭✭✭✭✭
    Options

    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.

    Hope this helps and that you have a great day,

    Jason Albrecht MBA, MBus(AppFin), DipFinMgt

    LinkedIn profile - Open to work

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!