How to add Date to cell by using the simple function DATE(year,month,day) that represents the date in Excel date-time code. This function is useful in situations where the year, month, day are supplied by cell references.
Step 1: Click the Formulas tab > Insert Function.
Step 2: Select Date & Time.
Step 3: Select Date function > OK.
Step 4: Enter numbers > click OK.