Apr 07 2021 03:27 AM
I have date column as 1.1.2021. and i would like to convert it as 20210101. can anyone help me ,,,
Thanks in advance.
Apr 07 2021 03:43 AM
Does the column contain 'real' dates, or are they text values that look like dates?
Apr 07 2021 05:03 AM - edited Apr 07 2021 05:08 AM
they look like date and are in 1.1.2021 form , but i converted to 1.1.2021 and are date column now....
Apr 07 2021 05:12 AM
Let's say the dates are in A2 and down.
Enter the following formula in B2 and fill down:
=TEXT(DATE(RIGHT(A2,4),MID(A2,FIND(".",A2)+1,FIND(".",A2,FIND(".",A2)+1)-FIND(".",A2)-1),LEFT(A2,FIND(".",A2)-1)),"yyyymmdd")
Apr 07 2021 11:25 AM
SolutionApr 07 2021 12:13 PM
That means that the values were already real dates, and not text values that look like dates. Your reply to my earlier question made me think it was the latter.
Apr 07 2021 11:25 AM
Solution