From 9d3ffe07f19282e1485f3312690727dbd5e53b09 Mon Sep 17 00:00:00 2001 From: Stanislav Horacek Date: Sun, 13 Oct 2013 18:44:10 +0200 Subject: correct example for EDATE function Change-Id: If081af7b6df824a780fa0fed197416b9403f4231 Reviewed-on: https://gerrit.libreoffice.org/6239 Reviewed-by: Andras Timar Tested-by: Andras Timar --- source/text/scalc/01/func_edate.xhp | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/source/text/scalc/01/func_edate.xhp b/source/text/scalc/01/func_edate.xhp index 7684e70de1..176438f3df 100644 --- a/source/text/scalc/01/func_edate.xhp +++ b/source/text/scalc/01/func_edate.xhp @@ -33,7 +33,7 @@ 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. +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. Syntax EDATE(StartDate; Months) @@ -41,8 +41,8 @@ Months is the number of months before (negative) or after (positive) the start date. Example -What date is one month prior to 3.31.2001? +What date is one month prior to 2001-03-31? -=EDATE(3.31.2001;-1) returns 2.28.2001. +=EDATE("2001-03-31";-1) returns the serial number 36950. Formatted as a date, this is 2001-02-28. -- cgit