the on that is not empty

[Jonathan78]

Hello all,

I thought this would be simple but couldn't get it done.
I got 2 rows with dates sometimes in one of them a date is missing
Now I would like in collomn D a list that looks in both collumns and picks out the one that has a date

[DonkeyOte]

If the dates are the same (as implied)

E3: =MAX(B3;C3)
copied down

If not the same and you want the last

E3: =LOOKUP(9.99999999999999E+307;$B3:$C3)
copied down

or of course

E3: =IF(ISNUMBER($C3);$C3;$B3)
copied down

[Jonathan78]

Thanks DonkeyOte,
The MAX-formula did the trick

[Jonathan78]

How do you amend these formula to check multiple cells [3 instead of 2]