then just use MAX

=MAX(IF(A1:A100<TODAY(),A1:A100))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"edwardpestian"
wrote in message
...

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