LearnFast.Ninja

Enter date in Excel 2010

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.


Result:


Tags

excel

date