MMDD and YY columns

[Anonymous]

Hello Everyone,

I have 2 columns below, how can I convert them to a proper date format like 1/4/2021? Thanks in advance.

[Nathaniel_C]

Hi @Anonymous ,

You are welcome!

Nathaniel

[Anonymous]

Thanks so much, it works @Nathaniel_C 

[Nathaniel_C]

Hi @Anonymous ,

Go to Power Query - Split the column by the 2 right characters, join the three columns with "/" and change to date.


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[Nathaniel_C · Accepted solution]

[Nathaniel_C]

Hi @Anonymous ,

If this solves your issues, please mark it as the solution, so that others can find it easily. 
Nathaniel