Hi all!

I have a row with a strings. The typical string is
"The Bonds shall be payable in three equal annual instalments on 30th November 2010, 2011 and 2012, and bear a semi annual coupon. Offert date:14.11.2008 Price:86.33613167, Offert date:18.11.2008 Price:83.54645761, Offert date:05.12.2008 Price:79.76367227,"

In some cell there is a date. The question is how to extract the earliest offert date from the above string which is greater than the date in some some cell.

I'm looking for the single formula. Anybody that can help, thanks a lot in advance!!!