Warning: This Help page is relevant to LibreOffice up to version 6.0.
For updated Help pages, visit https://help.libreoffice.org.

DATAE

From LibreOffice Help
Jump to: navigation, search

DATAE

The result is a date which is a number of months away from the start date. Only months are considered; days are not used for calculation.

Sintaxi

DATAE(DataInicial; Mesos)

DataInicial és una data.

Mesos és el nombre de mesos abans (negatiu) o després (positiu) de la data d'inici.

Exemple

Quina és la data un mes abans del 31/03/2001?

=EDATE("2001-03-31";-1) returns the serial number 36950. Formatted as a date, this is 2001-02-28.