HomePrivacy PolicyFeedbackLink to usSite Map

MS Excel: Year Function


In Excel, the Year function returns a four-digit year (a number from 1900 to 9999) given a date value.

The syntax for the Year function is:

Year( date_value )

date_value is a valid date.


Applies To:

  • Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Year(A1) would return 1999.
=Year(A2) would return 2001.
=Year(A3) would return 2003.

VBA Code

The Year function can also be used in VBA code. For example:

Dim LYear As Integer

LYear = Year("12/03/2001")

In this example, the variable called LYear would now contain the value of 2001.