tech on the net

MS Excel: YEAR Function (WS, VBA)

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

Syntax

The syntax for the YEAR function is:

YEAR( date_value )

date_value is a valid date.

Applies To

Type of Function

Worksheet Function Example

Let's take a look at an example to see how you would use the YEAR function in a worksheet:

Microsoft Excel

Based on the Excel spreadsheet above, the YEAR function would return the following:

=YEAR(A1) would return 1999
=YEAR(A2) would return 2001
=YEAR(A3) would return 2003

VBA Function Example

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.