Q:

Excel max value return

I have this excel sheet 

I want cell H4 to show the date (column A) corresponding to the maximum value in column H.
In this case it should be 15/1/2016
I would appreciate any help

A:

You can use the following formula:
=INDEX($A$6:$A$13,MATCH(MAX($H$6:$H$13),$H$6:$H$13,0))

You may need to format the cell as a date to display correctly.

