YEAR
Syntax:
YEAR ( date-value )
Description: Computes the numeric Gregorian year for the date and/or time having the given date-value, taking into account the current date base value. That date and/or time shall be expressed either as a serial value, in which case, its fractional part is ignored, or as a string-constant having any valid date and/or time format, in which case, any time information shall be ignored.
Arguments:
Name |
Type |
Description |
|---|---|---|
date-value |
number, text |
The date and/or time whose year is to be computed. That date and/or time shall be expressed either as a serial value, in which case, its fractional part is ignored, or as a string-constant having any valid date and/or time format, in which case, any time information shall be ignored. |
Return Type and Value: number – The Gregorian year for the date and/or time having the given date-value. For the 1900 date base system, the returned value shall be in the range 1900–9999. For the 1904 date base system, the returned value shall be in the range 1904–9999.
However, if date-value is out of range for the current date base value, #NUM! is returned.