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.

Find more posts tagged with

Formulas

Accepted answers

Jason Albrecht

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

All comments

Jason Albrecht

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

Syed Muhafzal

@Jason Albrecht

Perfect - thanks Jason. Yup this helps!

Syed

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.