Count items due in the next year (365 days)

Hi All,

I am trying to use a COUNTIF formula with a TODAY function to count the number of items with due dates in the next year. I'm currently using this formula.

=COUNTIF([Next Task Due Date]:[Next Task Due Date], <TODAY(365))

It returns a "0" for the number, however, there are several items where the "next task due date" is within the next 365 days.

Any ideas?

Thanks!

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @swirt009

I hope you're well and safe!

Ensure that the Next Task Due Date is a date column.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

swirt009

Thank you! That's why it's not working. I appreciate your help.

Andrée Starå

@swirt009

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.