I have tried your formula and found that there is an issue (maybe my mistake!) only made the following change and that was to take the range a2:a1500 and also I2: I1500

on some training carried out 19 nov 07 valid 5 years expiry date is 18 nov 2012..... using your formula it comes up as expired and this clearly isnt the case. What have I done wrong?