Count items due in the next year (365 days)

Hi All,

I am trying to use a COUNTIF formula with a TODAY function to count the number of items with due dates in the next year. I'm currently using this formula.

=COUNTIF([Next Task Due Date]:[Next Task Due Date], <TODAY(365))

It returns a "0" for the number, however, there are several items where the "next task due date" is within the next 365 days.

Any ideas?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!