Formula for Filter: Not in the last (x) days

A Rose

Hi,

What formula gives me the same value as the above filter?

Would need something like COUNT IF {Range 1} Is Not in the last (x) days

Thank you!

Paul Newcome

Assuming you would want to count only dates that are in the past (not future dates even though they are technically not in the last x days)...

=COUNTIFS({Range 1}, @cell < TODAY(-X))

Paul Newcome

Assuming you would want to count only dates that are in the past (not future dates even though they are technically not in the last x days)...

=COUNTIFS({Range 1}, @cell < TODAY(-X))

A Rose

Thank you @Paul Newcome !

Paul Newcome

Happy to help. 👍️