Identify right most date with conditions

[The Grim Discovery]

Hello Excel people

I've got a simple 6 column table like the one below.
Columns A - E contain mostly dates.
Column F copies the right-most date by using the following formula: =LOOKUP(2,1/(A2:E2<>""),a2:e2)
Which works fine when only dates are input. But I've recently had cause to introduce 'N/A' and 'Nil' as possible input options as well as dates. And this causes a problem for me in Col F because, as in the example below, it's no longer telling me the most recent date (which should be 12/12/22 from Col D) but is copying the cell contents of Col E and returning 'Nil'.

Can anyone help with adapting/overhauling the formula so it ignores instances of 'N/A' and 'Nil' and only recognises dates?

Lots of thanks in advance.

A	B	C	D	E	F
Date 1	Date 2	Date 3	Date 4	Date 5	Most recent date
1/6/22	5/7/22	10/8/22	12/12/22	Nil	Nil

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=LOOKUP(2,1/(ISNUMBER(A2:E2)),A2:E2)

 

[The Grim Discovery]

=LOOKUP(2,1/(ISNUMBER(A2:E2)),A2:E2)

Yep, that nailed it, thanks very much Fluff. You've saved me a tonne of hassle and time. Cheers.

 

[Fluff]

You're welcome & thanks for the feedback.