Thread
:
Function to Return a Date Value Q
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
Function to Return a Date Value Q
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
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch