YEAR

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

Sintakse

YEAR(Skaitlis)

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

Piezīmes ikona

YEAR() returns the integer part of the year.


Piemēri

=YEAR(1) atgriež 1899

=YEAR(2) atgriež 1900

=YEAR(33333.33) atgriež 1991

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

Technical information

Piezīmes ikona

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!