ÁR

Returns the year as a number according to the internal calculation rules.

Notkun

YEAR(Tala)

Number shows the internal date value for which the year is to be returned.

Táknmynd fyrir athugasemd

YEAR() returns the integer part of the year.


Dæmi

=YEAR(1) skilar 1899

=YEAR(2) skilar 1900

=YEAR(33333.33) skilar 1991

=YEAR(DATEVALUE("2010-09-28")) returns 2010.

Technical information

Táknmynd fyrir athugasemd

This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)


Please support us!

Please support us!