YEAR Function

Basic Description

The Excel Year function returns an integer representing the year of a supplied date.

Syntax: YEAR( serial_number )

where the serial_number argument is the date that you want to return the year from. This can be supplied to the Year function as either a reference to a cell containing a date or a date returned from another function or formula

Warning: If you attempt to input the date argument as text, there is a chance that Excel may misinterpret this due to different date systems, or date interpretation settings.


Year Function Examples

The following example shows the Year function used to extract the year from 3 different dates.

1 Date Year
2 29-May-2012 =YEAR( A2 )
3 05/03/1984 =YEAR( A3 )
4 =YEAR( DATE(2013, 1, 1) )
1 Date Year
2 29-May-2012 2012
3 05/03/1984 1984
4 2013

Note that, in the above examples, as recommended by Microsoft, the serial_number argument is always supplied as either a reference to a cell containing a date, or as a value returned from another function.


Download Documents

Download Excel File

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



clearPost Comment