YEAR
Returns the year as a number according to the internal calculation rules.
This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)
YEAR(Number)
serial_number 顯示計算年份數字的內部日期數值。
=YEAR(1) 傳回 1899
=YEAR(2) 傳回 1900
=YEAR(33333.33) 傳回 1991
=YEAR(DATEVALUE('2010-09-28')) returns 2010.