US dates to UK??
Bill,
if your date/times are imported as text, then the following formula
will do (assuming dates are past Y2K).
=DATE(VALUE(20&MID(A1,FIND("/",A1,FIND("/",A1)+1)+1,FIND("
",A1)-FIND("/",A1,FIND("/",A1)+1)-1)),LEFT(A1,FIND("/",A1)-1),MID(A1,FIND("/",A1)+1,FIND("/",A1,FIND("/",A1)+1)-FIND("/",A1)-1))
HTH
Kostis Vezerides
|