Returning the next date that matches the criteria

[Corleone]

Hi
Im currently using the formula below to return the latest date from the source data that matches the criteria as there are in some cases multiple records with the same

=MAXIFS('All Milestone Report'!$W$2:$W$20000,'All Milestone Report'!$U$2:$U$20000,V23)

is there a way of adjusting it so that it picks up the earliest date but also ensuring that it only looks for dates on or after today

Thanks

 

[Fluff]

Maybe

=MINIFS('All Milestone Report'!$W$2:$W$20000,'All Milestone Report'!$W$2:$W$20000,">="&TODAY(),'All Milestone Report'!$U$2:$U$20000,V23)

 

[Corleone]

That works - Thank you

Maybe

=MINIFS('All Milestone Report'!$W$2:$W$20000,'All Milestone Report'!$W$2:$W$20000,">="&TODAY(),'All Milestone Report'!$U$2:$U$20000,V23)
[/QUOTE]

 

[Fluff]

You're welcome & thanks for the feedback.