=--TEXT(A1,"0000-00-00")

Format cell as: DATE


"pgarcia" wrote:

How can I fix this? I had used a formula years back but can't remmeber how it
goes. Thanks

=DATE(right(A1,2),mid(a1,5,2),left(A1,4))

but it does not work.

Thanks