How to write a COUNTIF formula that counts the amount of rows where the date is TODAY-date>80 AND

Abbie G

TODAY-date<99?

Lidiya S.

Hello @Abbie G

Try this:

=COUNTIFS([Column20]:[Column20], >TODAY(+80), [Column20]:[Column20], <TODAY(+99))

Just replace [Column20]:[Column20] with the column that your Date is in.

Let me know how it goes!

Lidiya Shutaya

[email protected]