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