On Monday, June 25, 2012 7:14:39 PM UTC+1, Claus Busch wrote:
Hi Sean,

Am Mon, 25 Jun 2012 10:55:06 -0700 (PDT) schrieb :

Thanks the 'same or earlier' doesn't really work for me, as the closest might be greater than todays date

try:
=MIN(IF(ABS(A5:E5-$A$1)=MIN(ABS(A5:E5-$A$1)),A5:E5))
and enter the formula with CTRL+Shift+Enter


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Bingo! that seems to have worked great, Thanks