EDATE

From 940b4d1848e8c70ab7642901a68594e8016caffc Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 27 Apr 2024 18:51:28 +0200 Subject: Adding upstream version 1:7.0.4. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/01/func_edate.xhp | 49 ++++++++++++++++++++++++ 1 file changed, 49 insertions(+) create mode 100644 helpcontent2/source/text/scalc/01/func_edate.xhp (limited to 'helpcontent2/source/text/scalc/01/func_edate.xhp') diff --git a/helpcontent2/source/text/scalc/01/func_edate.xhp b/helpcontent2/source/text/scalc/01/func_edate.xhp new file mode 100644 index 000000000..14b050236 --- /dev/null +++ b/helpcontent2/source/text/scalc/01/func_edate.xhp @@ -0,0 +1,49 @@ + + + + + +EDATE +/text/scalc/01/func_edate.xhp + + + +EDATE function + +

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(StartDate; Months) + +StartDate is a date. + +Months is the number of months before (negative) or after (positive) the start date. +

+What date is one month prior to 2001-03-31? + +=EDATE("2001-03-31";-1) returns the serial number 36950. Formatted as a date, this is 2001-02-28. +

+ + -- cgit v1.2.3