Documentation/Calc Functions/YEAR/en

Function name:
YEAR

Category:
Date and Time

Summary:
Calculates the year for a date specified either by a date-time serial number or in a text string.

Syntax:
YEAR(Date)

Returns:
Returns a positive integer which is the year value of the supplied date.

Arguments:
Date is the date (in quotation marks) or a date-time serial number, or a reference to the cell containing one of those types, which is the date for which the calculation is to be carried out. Date can be any date in the year of interest.


 * If Date is not a valid date expression, then YEAR reports a #VALUE! error.
 * YEAR ignores any time components of Date.

Related LibreOffice functions:
DAY

MONTH

VALUE

ODF standard:
Section 6.10.23, part 2.

Equivalent Excel functions:
YEAR