Navigation:  Formula Reference > Spreadsheet Formula Functions >

YEAR

Previous pageReturn to chapter overviewNext page

 

This function returns the year as an integer for a specified date.

Syntax

YEAR(date)

Arguments

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 Date and Time Functions.

Remarks

The widget correctly treats the year 1900 as a non-leap year and uses a base date of 12/31/1899.

Data Types

Accepts numeric, string, DateTime object, or TimeSpan object data. Returns numeric data.

Examples

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

 

See Also

DATE

MONTH

TODAY

YEARFRAC