YEAR


Description Returns the year that corresponds to the supplied date.

Syntax YEAR ( serial_number )

Argument Description
serial_number The date as a serial number or as text (for example, 06-21-94 or 21-Jun-94).

Examples This function returns 1993:

YEAR(34328)

This function returns 1994:

YEAR("06/21/94")

See Also DAY, NOW, HOUR, MINUTE, MONTH, SECOND, TODAY, WEEKDAY