Change date format

[Dominic-2019]

Dear all,

I have elaborated the question in the sample workbook.

Thank you.

[sweep]

Hi,

The following works for your example.

=DATE(RIGHT(A2,4),LEFT(A2,2),MID(A2,4,2))

[Kaper]

You can use:

Please Login or Register  to view this content.

and copy down

other option is to use "text to columns" tool from data ribbon - make sure you mark column1 ad date with MDY format