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![]()
Bookmarks