How to write a countif formula that counts the dates in the column that is 15 days more than todays

Abbie G

date?

James Keuning

=COUNTIF(DateColumn:DateColumn, =(TODAY() - 15))

That assumes you actually want exactly 15 days. If you want more than 15 days, change the = to >

Abbie G

James Keuning

=COUNTIF(DateColumn:DateColumn, =(TODAY() - 15))

That assumes you actually want exactly 15 days. If you want more than 15 days, change the = to >

Abbie G

Thank you @James Keuning

Abbie G

Cyndi

@James Keuning - I found this in searching for my answer and I think I'm still doing something wrong - I am referencing a range in another sheet and I get unparsable

=COUNTIF({Date Reported}, >TODAY() - 30))

and then my next question (just to get it out there) is that I will want to find dates that are between 31 and 60 days old from today

I won't even think about trying to add in How Many Tickets are over 30 days from today in "Open" status 😀