Year

Returns an integer between 100 and 9999, inclusive, that represents the year of a date argument.

Arguments

Year( dateexpression [, firstweekday] [, firstweek])

Notes

The argument dateexpression is any numeric expression that can represent a date and/or time from January 1, 100 through December 31, 9999, where January 1, 1900 is 2. Numbers to the left of the decimal point in dateexpression represent the date; numbers to the right represent the time. Negative numbers represent dates prior to December 30, 1899. If dateexpression is Null, this function returns a Null.

The firstweekday argument is an optional integer argument that specifies the first day of the week. For example, 0=Use the First Weekday setting in the Options dialog box, 1=Sunday (default), 2=Monday, 3=Tuesday, etc.

The firstweek argument is an optional integer argument that specifies the first week of the year. Use the following values: 0=Use the First Week setting in the Options dialog box, 1=Start with January 1, 2=Start with the first four-day week, 3=Start with the first full week.