title: Excel function about Date
body: <p>i want to know the function to get .01.09.2016 from 1/9/2016 in excel.I applied this function "=DATE(LEFT(A1,4),MID(A1,4,20),RIGHT(A1,2))" but this gives result 17.08.4243 from 09/01/2016 and also customized these two cells as dd/mm/yyyy and dd.mm.yyyy.</p>