Update date in separate cell each time new data is entered.

I have two columns, one with the date, sequentially, and then one for the corresponding number/data for that day. I have a third cell that I just want to update to the most current date this has numbers entered. Hopefully the example below makes this clear. I feel like there should be a simple solution, but everything I Google only comes up with finding max or min dates, or the current date. VLOOKUP wont work because my dates will not always be to the left of the data. Any help much appreciated!

EDIT: The Date Column will always be the leftmost (Column A) but the column with the data being entered might be several columns over.

This seems to be working...
=OFFSET(INDEX(G8:G78,COUNTA(G8:G78, 1)),-1,-6,1,1)

G8:G78 being the column I am entering data in, and therefore the -6 being 6 columns to the right.

If anyone has any comments on this solution, or a simpler method, would love to learn more.