You can probably use a Pivot Table... just select MAX of instead of COUNT of for the Field Setting.

Or you can use formula:

=MAX(IF($A$2:$A$6=$A17,IF($B$2:$B$6=B$15,$E$2:$E$6)))

confirmed with CTRL+SHIFT+ENTER and copied down and over.. you can then format cells as Custom: m/d/yyyy;-0;;@ to hide 0's