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

Answers
-
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).
-
@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)
-
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(……………)))
-
@EmilyCamp sending you a tag to make sure you saw the responses above 🙂
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!