Sheet summary Next date in a range

sebastiani

HI,

I am having trouble writing a correct formula for a sheet summary that determines the next upcoming date from a column of dates. Screen shot attached.

Objectives:

Sheet summary of:

Next upcoming Quarterly

Next upcoming Orientation

Thanks!

Paul Newcome

You would use something along the lines of

=MIN(COLLECT([Date Column]:[Date Column], [Date Column]:[Date Column], @cell> TODAY()))

sebastiani

That worked!

Thanks :)

Paul Newcome

Happy to help. 👍️