DATEΒΆ

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

Syntax

=DATE(Years, Months, Days)

Arguments

Name

Description

Years

A number which specifies years

Months

A number which specifies months

Days

A number which specifies days

Return Value

The corresponding date as serial number.

Example

Function

Result

Comment

=DATE(2018, 5, 18)

43238

The given date value represents the 18th of May, 2018