Returns the year corresponding to a date.
Syntax
YEAR(serial_number)Argument
serial_numberobligatoriskt
The date of the year you want to find.
The YEAR function extracts the year from a given date as an integer in the range 1900-9999. It is commonly used to isolate the year component from a full date for data analysis or reporting purposes.
=YEAR("2023-12-25")→2023Extracts the year from the specified date string.
Select a cell
Click on the cell where you want the result to appear.
Enter the formula
Type =YEAR(A1) assuming your date is in cell A1, then press Enter.
Excel will return a #VALUE! error.