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

EDATE

From LibreOffice Help
Jump to: navigation, search

EDATE

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.

構文

EDATE(開始日; 月)

開始日 は、日付です。

は、開始日の前 (負の数) またはあと (正の数) の月数です。

2001年3月31日より1ヶ月前の日付を求めます。

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