Lookup value furthest to the right + criteria

Hi,

I've not been able to find an answer to this anywhere online so I hope someone can help.

I have a range of dates for a series of interviews with different people.

This range includes the dates of ones that have occurred and ones that are scheduled for the future.

I want a column that returns the date of the latest interview that has taken place.

A simplified version of my data is below:

Screen Shot 2018-05-28 at 14.36.30.png

Originally I only had the dates of interviews that had taken place, and used the formula =LOOKUP(99^99,D3:M3) to return the value furthest to the right, as this would be the latest interview. Obviously now the date furtherest to the right is not most recent interview, and so I need the formula to return the value furthest to the right that is not in the future.

Hope that makes sense! Would be grateful for any help.

With Today's date in C1 (i.e. =TODAY())

Formula:

=LOOKUP(2,1/(($D3:$M3<=$C$1)*($D3:$M3<>"")),$D3:$M3)