Excel - Return column header for the rightmost value?

Question

I've got a spreadsheet with various dates across my columns (the headers). In the next row, I have data values in some, but not all, of the cells in that row. At that end of that row, I have a "latest data" column, and I would love to find a formula that would look through my row of data, find the rightmost (most recent) data point, and return the column header (date).

Here is an example of my setup and what I would like it to return.

Thanks!

Answer 1

=INDEX($B$1:$K$1,MAX(COLUMN(B2:K2)*(B2:K2<>""))-COLUMN(B2)+1)

Answer 2

Hi,

In cell K2, enter this formula and drag down

=xlookup(true,A2:J2<>"",$A$1:$J$1,,,-1)

Hope this helps.