Tasks due in the next 5 days

Hi Smarties,

Need help here.

I want to know how many tasks are there due'd in the next 5days. I thought this was easy but somehow not getting the result!

Let's say today is 18th Aug, from the below, the result should be 1 (19th Aug).

However, my formula returns 2 in the sheet summary.

This is the formula I used to find out how many tasks are there due in future from today + 5 days.

=COUNTIF([Estimated Completion Date]:[Estimated Completion Date], <=TODAY(+5))

Appreciate your advice in advance.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!