Forum Discussion
Translating serial numbers into date codes
I have an excel file with a column with dates in the format dd.mm.yyyy. In some of the cells, there are more than one date or commas and semi commas. I want only to have ten digits counted from the l...
Hi,
I suggest to use the below formula to extract each part of the date and format it in the desired format:
=TEXT(DATE(MID(A1,7,4),MID(A1,4,2),LEFT(A1,2)),"dd.mm.yyyy")
Hope that helps
