Office 24.2 帮助
Returns the year as a number according to the internal calculation rules.
此功能是「用于 Office 应用程序的开放文档格式 (OpenDocument)」标准 1.2 版本的一部分。(ISO/IEC 26300:2-2015)
YEAR(数字)
「serial_number」处给出的是要转换成相对应年份数的日期内部序列数。
「=YEAR(1)」返回 1899
「=YEAR(2)」返回 1900
「=YEAR(33333.33)」返回 1991
=YEAR(DATEVALUE("2010-09-28")) returns 2010.
相关主题
YEAR wiki page.
Date & Time Functions
DATE
DATEDIF
DATEVALUE
DAY
DAYS
DAYS360
DAYSINMONTH
DAYSINYEAR
EASTERSUNDAY
EDATE
EOMONTH
HOUR
ISLEAPYEAR
ISOWEEKNUM
MINUTE
MONTH
MONTHS
NETWORKDAYS
NETWORKDAYS.INTL
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WEEKNUM
WEEKNUM_EXCEL2003
WEEKNUM_OOO
WEEKS
WEEKSINYEAR
WORKDAY
WORKDAY.INTL
YEAR
YEARFRAC
YEARS