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

MichelleR

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))

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))

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