Thanks for the advice I have sorted it now. Converted the text to dates(which were all in US format) by removing the / and then using a =DATE(MID(A3,1,4),MID(A3,5,2),MID(A3,7,2)) formula.