Microsoft Excel Tips - Function extract the year number from a date

[denizen]

Date Year 25-Dec-98 1998 =YEAR(C4)

What Does It Do? This function extracts the year number from a date.

Syntax =YEAR(Date)

Formatting The result is shown as a number.