How to change DDMMYY into date format in MS Excel?

Hi, if you have some data on a worksheet that contain value like DDMMYYYY and would like to convert them all into date format. Here is the formula.

Say, On column A shown as 01122016 and etc...Then you need to apply this formula into column B
as below :

=DATE(RIGHT($A1,4),MID($A1,3,2),LEFT($A1,2))

or =DATE(MID($A1,5,4),MID($A1,3,2),MID($A1,1,2))

The function arguments would vary depending the number of dd,mm,yyy used. Eg 01 and 1 for day

Hope that helps...