Forum Discussion
Return next date
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
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
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
Hi, the formula works great, but can you update it for this revised spreadsheet? I tried and cannot get it to work. I added more columns I need to include in the formula.MindreVetande