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
- Hi. You have a mix of table and nontable areas in the new file. If you use traditional references i F2 this should work:
=AGGREGATE(15,6,(G2:AD2)/(G2:AD2>TODAY()),1)
or, if want to hide the errors:
=IFERROR(AGGREGATE(15,6,(G2:AD2)/(G2:AD2>TODAY()),1),"")
Expand the table and Change G2:AD2 to Table-references if you prefer that.Attached file with formula, but I think I ruined your date format.
- That worked! Thank you so much for your help.