Tasks due in the next 5 days
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.
Help Article Resources
Check out the Formula Handbook template!