Formula to calculate Next Due date

Zygon

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?

Paul Newcome

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