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

date?

• ✭✭✭✭✭

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

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

• ✭✭✭✭✭

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

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

• Thank you @James Keuning

• ✭✭

@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 😀

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!