Skip to main content
Version: Streamsheets 3.0

YEAR

Returns the year of the date value.

Syntax

=YEAR(DateValue, [Round])

Arguments

NameTypeDescription
DateValueNumberA serial number consists out of two numbers. The number to the left of the decimal define the days since 01.01.1900. The number to the right of the decimal define the fraction of the day.
Round (optional)BooleanDefines, if value should be rounded.

Default value: TRUE

Return

TypeDescription
NumberYear evaluated from date value.

Examples

FormulaResultComment
=YEAR(43238)
2018The given date value represents the 18th of May, 2018
=YEAR(39447.99999422, true)
2008Rounded to 2008
=YEAR(39447.99999422, false)
2007Same input value as before but no rounding applied