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


#1

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.