LibreOffice 24.8 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.