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
This will give you the smalest (next) date that is bigger (later) than today
=MINIFS(Table28[@],Table28[@],">"&TODAY())
=MINIFS(Table28[@],Table28[@],">"&TODAY())
- I cannot get that formula to work.
When I download your attachment I can see the formula works correctly. However, when I click "Enable Editing" the value turns to #Name? and no longer shows the date. MindreVetande
