I have a spreadsheet similar to the attached sample. I need a formula ro return the latest date from a range of cells which is less than the current date. If all dates in the range are later than the current date then it should return the minimum date. This is hard to explain so if todays date is 13/9/2012 and a dates in the cells are 12.1.2012 & 14/8/2012 then the formula should return 14/8/2012. If the dates in the cells are 12/11/2012 and 14/12/2012 then the formula should return 12/11/2012.
Hope this makes sense