It combines three separate values to form a date and returns that date.
The syntax of the function is the following:
DATE(year, month, day)
year: The year of the date we want to create. If it is less than 1900 then it adds that value to 1900. If it is less than 0 or greater than 9999 it returns the #NUM! error.
month: The value that represent the month of the year. If the value is greater than 12 or less than zero it adds or subtracts respectively that number to the first month of the year.
day: The value that represent the day of the month. If the value is greater than the number of days in the month or less than zero it adds or subtracts respectively that number to the first day of the month.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here are some examples of how to use the DATE function:
Insert an appropriate function in the cell C3 to return a date using the year appearing in the cell C2, the month appearing in the cell Β3 and the 1st day of the month. Reproduce the function in the cell range C3:G14 using the same pattern.
Use the function date(), to insert the date 9 July 1968 in the cell C5.
Insert an appropriate function in the cell Ε2 to return the date for the values of the cell range A2:C2. Reproduce the function in the cell range Ε3:Ε11.