DATE

Explanation

DATE function allows us to create a date from individual numbers which represent the day, month and year.

Syntax

=DATE(year,month,day)

year – The value of the year 

month – The value of the month

day – The value of the day

Example

Practice DATE function

 10 Essential Excel Tips for Data Analysis