Ano

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

Icona Nota

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


Sintaxe

Year (Número)

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

Exemplo

YEAR("2/22/2002") devolve 2002

YEAR("2/22/2002") devolve 2002

YEAR(2323.1285) devolve 1906

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

Funcións de data e hora

DATA

[text/scalc/01/func_datedif.xhp#datedif not found].

[text/scalc/01/func_datevalue.xhp#datevalue not found].

[text/scalc/01/func_day.xhp#day not found].

[text/scalc/01/func_days.xhp#days not found].

[text/scalc/01/func_days360.xhp#days360 not found].

[text/scalc/01/func_eastersunday.xhp#eastersunday not found].

[text/scalc/01/func_edate.xhp#edate not found].

[text/scalc/01/func_eomonth.xhp#eomonth not found].

[text/scalc/01/func_hour.xhp#hour not found].

NUMSEMANAISO

[text/scalc/01/func_minute.xhp#minute not found].

[text/scalc/01/func_month.xhp#month not found].

NETWORKDAYS

NETWORKDAYS.INTL

[text/scalc/01/func_now.xhp#now not found].

[text/scalc/01/func_second.xhp#second not found].

[text/scalc/01/func_time.xhp#time not found].

[text/scalc/01/func_timevalue.xhp#timevalue not found].

[text/scalc/01/func_today.xhp#today not found].

WEEKDAY

NUMSEMANA

NUMSEMANA_EXCEL2003

NUMSEMANA_OOO

[text/scalc/01/func_workday.xhp#workday not found].

WORKDAY.INTL

[text/scalc/01/func_year.xhp#year not found].

FRACCIÓNANO

Precisamos da súa axuda!