Formula to calculate Next Due date

I have a column that calculates Due date (a yr in advance) and in a different sheet it's compiling by name of person, Due Date and how many they have accumulated so far. I want the column of DUE DATE to give me the next Due date - Today. Meaning if the Due date falls on TODAY then it removes it from the formula.

this is what I was using which works but doesn't drop out today's date:

=MIN(COLLECT({Due Date}, {Combined name}, [Combined Name]@row))

is there that from the formula it removes today from the equation and give me the NEXT due date?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You would use another range/criteria set where the range is the due date column and the criteria is greater than today.

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.