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
- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Function
- Worksheet function (WS)
- VBA function (VBA)
Worksheet Function Example
Let's take a look at an example to see how you would use the YEAR function in a worksheet:
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.