LibreOffice 24.2 Help
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.
相關主題
YEAR wiki page.
Date & Time Functions
DATE
[text/scalc/01/func_datedif.xhp#datedif not found].
DATEVALUE
DAY
DAYS
DAYS360
DAYSINMONTH
DAYSINYEAR
EASTERSUNDAY
EDATE
EOMONTH
HOUR
ISLEAPYEAR
[text/scalc/01/func_isoweeknum.xhp#isoweeknum not found].
MINUTE
MONTH
MONTHS
NETWORKDAYS
NETWORKDAYS.INTL
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WEEKNUM
WEEKNUM_ADD
[text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo not found].
WEEKS
WEEKSINYEAR
WORKDAY
WORKDAY.INTL
YEAR
YEARFRAC
YEARS
Please support us!