COUNTIF date is within 30 days -- not calculating correctly

In the sheet summary, I am trying to count if the date in the date columns falls within the next 30 days. It's working fine for Date 1 column, but not for Date 2 column (or the copy of date 2 I created to verify).

This is my formula: =COUNTIF([Date 2]:[Date 2], <=TODAY(30))

It's calculating a number, I am not getting an error, but the calculation is not accurate. I have built filters and checked the dates manually and it's not adding up at all!

What could be causing this issue?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!