# Days Since Tickets Were Created

✭✭✭✭✭
edited 08/25/22

Hello,

I need some help with this formula, I am trying to create a datasheet that can pull in tickets from another grid & tell me how many tickets were opened within these timeframes.

30 days ago, 31 - 90 days ago, 91 - 180 days ago over 181 days ago.

I've done similar formulas with this for finding things between dates, but having trouble putting this together. Would appreciate if someone can help and take a look at this?

=COUNTIFS(AND({Priority}, Critical1, TODAY(30){Creation Date} ))

Tags:

• ✭✭✭✭✭✭

Try this...

=COUNTIFS({Priority}, @cell = Critical1, {Creation Date}, AND(DATEONLY(@cell)>= TODAY(-30), DATEONLY(@cell)<= TODAY()))

• ✭✭✭✭✭

Thank you @Paul Newcome, this works for 30 days, but could you also alter this formula so it also these other criteria?

Between 30 & 90 Days

Between 91 & 180 Days

Over 180 Days

• ✭✭✭✭✭✭

Yes. You would adjust the numbers within the TODAY functions accordingly except for the 180+. In that case you would not need the AND function. You would only need the single criteria set of less than TODAY(-180).

• ✭✭✭✭✭

Thanks @Paul Newcome , I have the 180 set, however I'm not sure how to phrase this so I get the count in between. Would you be able to provide these ones please?

Between 30 & 90 Days

Between 91 & 180 Days

• ✭✭✭✭✭✭

It would be the same as my previously posted formula but you would change the numbers inside of the TODAY functions.