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