Forum Discussion
Solved
Excel Date
I have date column as 1.1.2021. and i would like to convert it as 20210101. can anyone help me ,,, Thanks in advance.
- Thank you for your solution but I found out an easy way to change to the format i need... Format on custom ... and type the format you need,, in the space provided as Type: yyyymmdd. Problem solved !!!
Does the column contain 'real' dates, or are they text values that look like dates?
they look like date and are in 1.1.2021 form , but i converted to 1.1.2021 and are date column now....
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")
- Thank you for your solution but I found out an easy way to change to the format i need... Format on custom ... and type the format you need,, in the space provided as Type: yyyymmdd. Problem solved !!!
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.