Returns the year corresponding to a date.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
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.
=YEAR("2023-12-25")תוצאה: 2023
Extracts the year from the specified date string.
Excel will return a #VALUE! error.