Skip to main content

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 or an Error Code

Example

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