{"id":968,"date":"2019-04-25T15:29:22","date_gmt":"2019-04-25T12:29:22","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=968"},"modified":"2019-04-25T15:29:25","modified_gmt":"2019-04-25T12:29:25","slug":"the-date-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-date-function\/","title":{"rendered":"The DATE Function"},"content":{"rendered":"\n

It combines three separate values to form a date and returns that date. <\/p>\n\n\n\n

The syntax of the function is the following: <\/p>\n\n\n\n

DATE<\/strong>(year, month, day<\/b><\/span><\/em>) <\/p>year: <\/strong>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: <\/strong>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: <\/strong>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. <\/cite><\/blockquote>\n\n\n\n

<\/div>\n\n\n\n\n
<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here are some examples of how to use the DATE function:<\/strong><\/p>\n\n\n\n

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 \u03923 and the 1st day of the month. Reproduce the function in the cell range C3:G14 using the same pattern.<\/p>\n\n\n\n

\n