Select nearest date after specified

[Clash]

Hi all,

I have already asked this question, but the answer I was given only looked at the nearest date and not the nearest date after.

So here goes; I have a table that looks at new starters and the date they started, and then a list of dates appointments offered (these dates can and often do precede to person joining us).

What I’m looking for the first chronological date AFTER the New start Date.

In row 3 this works; as it is the nearest date, but in row 4 however, it is the nearest date; but occurs before the New start Date, thus is incorrect.

Thanks in anticipation

Clash

[Ace_XL]

In c3 use this array formula

=MIN(IF(E3:K3>B3,E3:K3))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Copy down

[Clash]

Ace_XL, thank you, I've been pulling what little hair I have left out since yesterday.

You are a star, thanks again.