Xlookup help?

Hello. I don't understand the complete power of "xlookup" yet; I've previously been using Vlookup.

(all data below is fictious)

In Cell "AL3", I want Excel to grab the most recent "Aggregate ACB". All of the data (attached) below occurs in row 3 (imagine a very long, single row).

In the scenario below, in cell "AL3", I want Excel to look across columns "E3:K3", "L3:R3", "S3:Y3", and "Z3:AF3" for the latest date, which is always found in the first column of each "group". Once that latest date is found, I want Excel to grab the "Aggregate ACB" from that "group" (the "6th" column in each "group").

Is that possible? Does my explanation make sense?

Thanks for your help!