convert numeric value to date

[Anonymous]

I have data (dates )coming in 5 digit and 6 digit values. I need to convert them into dates but cant seem to get a solution for this. 

24th of november, 2017  :  241117

6th december, 2017  :  61217

Below is the data which i need to convert into date format "DD/MM/YY" or "MM/DD/YY"

[Ashish_Mathur · Accepted solution]

Hi,

This calculate column works

=DATE("20"&RIGHT(Table1[Date],2),MID(FORMAT(Table1[Date],"000000"),3,2),LEFT(FORMAT(Table1[Date],"000000"),2))

Hope this helps.