To enter a date in a cell, “/” or “-” characters are used. By default, a month comes first before a date in Excel’s date format. You may also use DATE function to combine three different values (of date, month and year) to form a date.
=DATE (year, month, day)
where arguments are:
year – The year to be used in the date.
month – The month to be used in the date.
day – The day to be used in the date.