DATE

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

Syntax

=DATE(Years, Months, Days)

Arguments

NameDescription
YearsA number which specifies years
MonthsA number which specifies months
DaysA number which specifies days

Return Value

The corresponding date as serial number.

Example

FunctionResultComment
=DATE(2018, 5, 18)43238The given date value represents the 18th of May, 2018