ANY

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

Sintaxi

ANY(Nombre)

Nombre indica el valor de la data interna per a la qual es retornarà l'any.

YEAR() returns the integer part of the year.

Exemples

=ANY(1) retorna 1899

=ANY(2) retorna 1900

=ANY(33333,33) retorna 1991

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

Informació tècnica

This function is part of the Open Document Format for Office Applications (OpenDocument) standard.

YEAR wiki page.

Funcions de data i hora

NETWORKDAYS.INTL