Enter a date into an empty, unformatted cell in your Microsoft Excel worksheet. The cell contents must include a month and four-digit year, with or without a specific day.

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 ...