Notifications
Clear all
General Excel Questions & Answers
4
Posts
2
Users
0
Reactions
15
Views
Topic starter
I have a column with a lot of dates
In improper structure -
Dodge 20080106
I need to convert them to normal structure - 06/01/2008
I would appreciate help
Leah
Posted : 15/11/2021 8:24 am
Topic starter
I need to convert this within the Power Query
How do you do that?
Posted : 15/11/2021 10:53 am
Hello,
Have you tried using the DATE function? You will also need to use the LEFT, MID and RIGHT functions to get the values for the date.
=DATE(LEFT(F2,4),MID(F2,5,2),RIGHT(F2,2))
Br,
Anders
Posted : 15/11/2021 12:29 pm
Posted : 15/11/2021 6:05 pm