I have columns of say five dates and a result date column and require calculating which of the other five dates the result date is nearest!
Is there a way in which I can do this at all?

Any assistance would be much appreciated.
Thx