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
-
Hi Syed,
Looks like there's an earlier, similar question that was answered by admin that may help?
https://community.smartsheet.com/discussion/61726/countifs-for-dates
Hope this helps and that you have a great day,
Jason
Answers
-
Hi Syed,
Looks like there's an earlier, similar question that was answered by admin that may help?
https://community.smartsheet.com/discussion/61726/countifs-for-dates
Hope this helps and that you have a great day,
Jason
-
Help Article Resources
Categories
Check out the Formula Handbook template!