If a cell is filled, post a different cells contents

Hi,

Hoping somebody could please provide some guidance. What I'm trying to achieve is below:
- I have daily dates cells L2:CH2
- To confirm when a cell task is completed, I'm putting in either an X or a time. So anywhere from cell L3 to CH3 there's an X or time.
- I want cell E3 to display when a task is due to be completed, so somehow it's got to read L3:CH3 and find the last filled out cell, then insert the due date from the corresponding cells L2:CH2.
- Some of the cells in L3:CH3 have multiple X/times, so I only want it to recognise the last cell in the row that was completed.

I'm thinking it's going to need to be VBA, but if someone knows how to do this, it would please be much appreciated.

Thanks,

Thanks for the welcome and the quick response.

If I directly copy your formula, it's giving my answer as 0. When I looked at the fields, it appears to reference the wrong cell numbers, so I changed it for index to cells L2:CH2 and match to L3:CH3.

Now it's giving my answer as N/A when I can see the answer for this cell should be the date in cell L2