The YEAR function returns the year for a given date/time value or date string.
YEAR(date)
date: A given date/time value or date string.
Examples
=YEAR(“4/6/88 11:59:22pm”) returns 1988.
=YEAR(NOW()) returns 2011 when calculated anytime during 2011.
