Question: how to set short date format in excel?
Answer: Select the dates you want to format.
On the Home tab, in the Number group, click the little arrow next to the Number Format box, and select the desired format - short date, long date or time.