YEAR

Description

Returns the year that corresponds to the supplied date.

Syntax

YEAR ( number )

Parameter	Description
number	A date represented as: A serial number (for example 40339, which represents the DATEVALUE) Text (for example, "06-21-11" or "5-Jun-13")

Examples

This function returns 2013:

YEAR(41430)

This function returns 2012:

YEAR("04/21/11")