Year function

Category: Date & Time

Summary

Four-digit year.

Syntax

Returns a Variant (Integer) containing a whole number representing the year.

Example

Example
This example uses the Year function to obtain the year from a specified date. In the development environment, the date literal is displayed in short date format by using the locale settings of your code.
Dim MyDate, MyYear
MyDate = #February 12, 1969# ' Assign a date.
MyYear = Year(MyDate) ' MyYear contains 1969.

Microsoft Support Page

https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/year-function

Back to Functions