Google Sheets-funktion

YEAR

Returns the year corresponding to a date.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

YEAR(serial_number)

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.

Argument

serial_numberobligatorisktThe date of the year you want to find.

Exempel

=YEAR("2023-12-25")

Resultat: 2023

Extracts the year from the specified date string.

Vanliga frågor

What happens if the serial_number is not a valid date?

Excel will return a #VALUE! error.

Relaterade funktioner

MONTH DAY DATE