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