Question: how to set auto date format in excel?
Answer: Select the cells you want to format.
Press CTRL+1.
In the Format Cells box, click the Number tab.
In the Category list, click Date.
Under Type, pick a date format. ... 
If you want to use a date format according to how another language displays dates, choose the language in Locale (location).