I would like to have the value populated (B1) when data is entered into A1 based on the latest date. I have no idea how to incorporate a max function together with an Index Match.

See screenshot below.
[![enter image description here](https://i.stack.imgur.com/xebd4.png)](https://i.stack.imgur.com/xebd4.png)

[![enter image description here](https://i.stack.imgur.com/TErWO.png)](https://i.stack.imgur.com/TErWO.png)