Max & Min with Relevant date

Hello,

Attached is a tiny shred of data from a very big file.

How do I get the relevant date to its Max or Min value?
I know how to use Max and Min but am not sure how to get the values corresponding date.
I dont think an =Left would work and am not sure how an =IF would apply.

Thank you,
Garth