Find earliest date before today based on criteria

I have a Excel file (giftcard) i need to return "earliest valid Giftcard nr." in column M.
Column A= "Giftcard no"
Column B= "Customer no"
Column D= "Giftcard valid to date"

A customer can have more then one (ex. customer no 0000208) "Giftcard".
The "Giftcard" is valid if "Valid to" is today or after

"Earliest valid giftcard no" need to be shown on all rows. If a "Giftcard" is before today or there is a earlier valid "Giftcard" it need to be shown in column M. So all giftcard with same "Customer no" has same "Ealiest valid giftcard no"

Thanks. in M2 it returns "earliest valid giftcard date". I need it to return the giftcard no.

Array formula take a lot of resources when i have 1000+ row so it could be nice if there was a better way...

It does not considerate if giftcard have expired (Date expire, before today)

Thanks! it works

Hope to find a way that is not that demanding

you can try this non array formula if you want..

=AGGREGATE(15,6,$D$2:$D$6/($C$2:$C$6=C2)/($D$2:$D$6>=TODAY()),1)