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:

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.