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 !!!
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.
- Anyways Thank you for your help....