Changing date as string to date format

HI

I am having problem in converting Date column as string to date format, when i am using date format "dd/mm/yy it is converting first two digit of strings as "mm" and next two as "dd" instead of "dd" and "mm" respectively

PHP Code: 

 Sub IdbiStatement () 
 Range("D1:E500").Select
    With Selection
    .NumberFormat = "MM/DD/yyyy"
    .Value = .Value


        
    End With
End Sub