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 !!!
6 Replies
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")
