LibreOffice 25.2 Help
Returns the year as a number according to the internal calculation rules.
YEAR(āϏāĻāĻā§āϝāĻž)
āϏāĻāĻā§āϝāĻž āĻ āĻā§āϝāύā§āϤāϰā§āĻŖ āϤāĻĨā§āϝ āĻŽāĻžāύ āĻĒā§āϰāĻĻāϰā§āĻļāύ āĻāϰ⧠āϝāĻžāϰ āĻāĻžāϰāύ⧠āĻŦāĻāϰ āĻĢāϞāĻžāĻĢāϞ āĻĒā§āϰāĻĻāĻžāύ āĻāϰā§āĨ¤
YEAR() returns the integer part of the year.
=YEAR(1) ā§§ā§Žā§¯ā§¯ āĻĢā§āϰāϤ āĻĒāĻžāĻ āĻžāϝāĻŧ
=YEAR(2) ⧧⧝⧝ā§Ļ āĻĢā§āϰāϤ āĻĒāĻžāĻ āĻžāϝāĻŧ
=YEAR(33333.33) ⧧⧝⧝⧧ āĻĢā§āϰāϤ āĻĒāĻžāĻ āĻžāϝāĻŧ
=YEAR(DATEVALUE("2010-09-28")) returns 2010.