Forum Discussion
Solved
Return next date
I created a spreadsheet that calculates upcoming well child visits for children in a program. I need to determine each client's next visit due date. What formula can I use?
My bad. MINIFS is newer than i remembered. You have to use excel 2019 or newer.
https://support.microsoft.com/en-us/office/minifs-function-6ca1ddaa-079b-4e74-80cc-72eef32e6599
so, let's make an old fashioned complicated solution with AGGREGATE...
attached again
Leila explains how it works in this video (at least i assume it is the right one)
https://www.youtube.com/watch?v=iezVva6tAE4
12 Replies
- This will give you the smalest (next) date that is bigger (later) than today
=MINIFS(Table28[@],Table28[@],">"&TODAY())- I cannot get that formula to work.
Who is the "client" in terms of the spreadsheet and what is the logic, which date shall be next due date? Perhaps you may add at least one desired result manually to illustrate.
