Use MIN in COUNTIF to count how many visits are scheduled for the next available date

System

This discussion was created from comments split from: Formula to display next/upcoming date from a list.

EmilyCamp

On a similar note, if I am trying to find the next future date within a column and use it within a COUNTIF formula, how would I use the MIN function?

Example: Count how many visits are scheduled for the next available date (after today).

Philip Robbins

@EmilyCamp you would probably need two columns. Something along the lines of:

Next Future Date =MIN(COLLECT(Range:Range,Range:Range,@cell>TODAY()))

Bookings Next Future Date =COUNTIF(Range:Range,[Next Future Date]@row)

Paul Newcome

You should be able to do it in a single column. Just drop the MIN/COLLECT into the COUNTIFS where you see [Next Future Date]@row.

=COUNTIFS([Column Name]:[Column Name], @cell = MIN(COLLECT(……………)))

Genevieve P.

@EmilyCamp sending you a tag to make sure you saw the responses above 🙂