Find last date in Row & return Header

I've been trying to resolve a formula that a row can go to the last date entry and return the header within that column.

Row H2-N2 has the headers for EACH columns (IE A,B,C,D,E,F,G)
Row H3-N3 has dates in each cell and want to find the last date in that row (K3) or it can be a colour.
Return this to E3 with header from K2

Many Thanks
Mike

@CARACALLA: Your formula gives me a circular reference error.
Maybe I'm missing something obvious?

@mikey141: if CARACALLA's solution works for you then great. If not here's a few questions . . .

I understand that you want to find the last date in a row, but beyond that I think some clarifications would be useful for any potential solver.

1) In your example why does the date in K3 impact cell E3? Why not H3 or C3 ??

2) You say "Return this [the last date in that row] to E3 with header from K2". What does "with header from K2" mean? What exactly are you expecting in E3?

3) "or it can be a colour" - what does this mean?

4) Assuming a formula can be found for what you want to do, what cells would be populated with that formula?

Hopefully your clarifications will be useful to a potential helper.

EDIT: ********* Disregard this post in its entirety - total confusion on my behalf.

Another alternative formula to be used in cell E3 is;

You may need to change ";" with "," depending on your Excel settings.

Please Login or Register  to view this content.

Sample file is attached...