How do you format a date in Excel? To format a date; the day is written first, the month second, then the year (dd-mm-yyyy), and in some countries such as some eastern countries like Iran, China ...