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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!