Can't see the original formula, but the array formula

=MAX(IF(D2:D4<TODAY(),D2:D4,0))

replace D2:D4 with the actual range you want to use, and press Ctrl Shift
Enter to get the value. If no dates match, you will get a Zero returned.
"edwardpestian" <edwardpestian.28xasy_1149500702.38@excelforum-nospam.com>
wrote in message
news:edwardpestian.28xasy_1149500702.38@excelforum-nospam.com...
>
> The formula seems to find the earliest date in the range as opposed to
> the latest date less than today. If I have 06/01/2006, 06/02/2006 and
> 06/03/2006, and today is the 06/10/2006, the formula should return
> 06/03/2006.
>
> Thanks Again.
>
> EP
>
>
> --
> edwardpestian
> ------------------------------------------------------------------------
> edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
> View this thread: http://www.excelforum.com/showthread...hreadid=548491
>