Skip to main content
Version: Streamsheets 2.5

DATE

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

Syntax

=DATE(Years, Months, Days)

Arguments

NameTypeDescription
YearsNumberThe year to be used, if a 2-digit number is entered, the current century is assumed
MonthsNumberThe month represented by a number between 1 and 12
DaysNuumberA number, which specifies the day of the month

Return

The corresponding date as serial number or an Error Code

Examples

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