Next Payment Due

EMA

Using MIN COLLECT to select from dates the next payment due date. Nothing is being returned. I can't figure out what I am doing wrong. Next step would be to select the value associate with the date.

=MIN(COLLECT([Year 1 Due]1, [Year 2 Due]1, [Year 3 Due]1, [Year 4 Due]1, [Year 5 Due]1, [Year 6 Due]1, <TODAY()))

Paul Newcome

Are all of those columns next to each other? If so, try this...

=MIN(COLLECT([Year 1 Due]@row:[Year 6 Due]@row, [Year 1 Due]@row:[Year 6 Due]@row, @cell < TODAY()))

EMA

Thank You. Solved! Your help is greatly appreciated!

Paul Newcome

Are all of those columns next to each other? If so, try this...

=MIN(COLLECT([Year 1 Due]@row:[Year 6 Due]@row, [Year 1 Due]@row:[Year 6 Due]@row, @cell < TODAY()))

EMA

Thank You. Solved! Your help is greatly appreciated!

Paul Newcome

Happy to help. 👍️