Return future dates only?

[MOB]

I'm using this formula to establish the earliest date in column AE

{=MIN(IF('PO''s'!$U$2:$U$30000=$C7,'PO''s'!$AE$2:$AE$30000))}

How can I amend this formula to return the earliest date after today? ie I want it to ignore historic dates.

TIA

 

[FormR]

Hi, you can try this, which does not need to be array entered.

=MINIFS('PO''s'!$AE$2:$AE$30000,'PO''s'!$AE$2:$AE$30000,">"&TODAY(),'PO''s'!$U$2:$U$30000,$C7)

 

[MOB]

Perfect, many thanks!