Formula Functions > Functions T to Z > YEAR |
This function returns the year as an integer for a specified date.
YEAR(date)
Specify the date argument as a number (as in 37806.5) a string (as in "7/4/2003 12:00"), or a DateTime object, as in DATE(2003,7,4). For more details on the date inputs, refer to the discussion in Date and Time Functions.
The Spread control correctly treats the year 1900 as a non-leap year and uses a base date of 12/31/1899.
Accepts numeric, string, DateTime object, or TimeSpan object data. Returns numeric data.
YEAR(A2)
YEAR(R2C1)
YEAR(0.007) gives the result (which may be different from Excel) 1899
YEAR(DATE(2004,8,9)) gives the result 2004
YEAR(38208) gives the result 2004
YEAR("8/9/2004") gives the result 2004
This function is available in product version 1.0 or later.
DATE | MONTH | TODAY | YEARFRAC | Date and Time Functions