YEAR

Description

Use this function to return the "year" component of a date as a 4-digit integer in the range 1900-9999 inclusive. Supported in Chains.

YEAR(serial_number)

This function has the following arguments:

Name	Required	Description	Valid input
`serial_number`	Yes	The date of the year you want to find.	A date entered using the DATE function, a cell reference, a number which is a valid date, or a formula which results in any of these. For example, use `DATE(2008,5,23)` for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

Use case	Formula	Explanation and Result
Extract the year value of a date contained in a cell.	`=YEAR(A2)`	This formula works in the following manner: It extracts the year value of the date in `(A2)`. Result: 2022.
Extract the year value of an integer (serial) date contained in a cell.	`=YEAR(A3)`	This formula works in the following manner: It extracts the year value of the integer (serial) date in `(A3)`. Result: 2023.
Extract the year value of a supplied integer (serial) date.	`=YEAR(23981)`	This formula works in the following manner: It returns the year value of the supplied number. This formula returns 1965.
Extract the year value of a date contained in a cell offset by a supplied value.	`=YEAR(A2)-45`	This formula works in the following manner: It takes the date value in cell `(A2)` and extracts the year value, then subtracts 45 (years). Result: 1978.
Extract the year value of a supplied date.	`=YEAR("2024/7/4")`	This formula works in the following manner: It returns the year value of the supplied date. Result: 2024.
Return a specified date using the year value in a cell.	`=DATE(YEAR(A2),4,15)`	This formula works in the following manner: `YEAR(A2)` determines the year value of the date in `(A2)`. `DATE(…,4,15)` combines that value with the supplied month (4) and day (15) values. Result: 1/15/2022.

The date must be in a valid date format and enclosed in quotation marks.
If YEAR is formatted as text and not in quotation marks, YEAR will return the value "1900".
Wildcards don't work with this function.