Hi Rory, that seem to work very well.

Can I ask how you managed to get the format to stay as YYYY-MM-DD even for the lines where the DD-MM could be transposed? In all of my attempts I'd get 2014-04-06 when it should have been 2014-06-04, and the formula "=TEXT(RC[-2],""YYYY-MM-DD"")" looks identical to my original one.

Regardless that's a fantastic result and much appreciated.

Cheers

David