Tasks due in the next 5 days

Syed Muhafzal · 08/18/21

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.

Jason Albrecht · 08/18/21

Hi Syed,

Looks like there's an earlier, similar question that was answered by admin that may help?

Jason Albrecht · 08/18/21

Hi Syed,

Looks like there's an earlier, similar question that was answered by admin that may help?

Syed Muhafzal · 08/18/21

Perfect - thanks Jason. Yup this helps!

Syed

Best Answer