DATE

Returns the serial number which represents the date for given years, months and days.

Syntax

=DATE(Years, Months, Days)

Arguments

Name	Type	Description
Years	Number	The year to be used, if a 2-digit number is entered, the current century is assumed
Months	Number	The month represented by a number between 1 and 12
Days	Nuumber	A number, which specifies the day of the month

Return

The corresponding date as serial number or an Error Code

Examples

Formula	Result	Comment
=DATE(2018, 5, 18)	43238	The given serial number represents the 18th of May, 2018