[Libreoffice-commits] help.git: source/text

Stanislav Horacek stanislav.horacek at gmail.com
Sun Oct 13 12:47:37 PDT 2013


 source/text/scalc/01/func_edate.xhp |    6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

New commits:
commit 9d3ffe07f19282e1485f3312690727dbd5e53b09
Author: Stanislav Horacek <stanislav.horacek at gmail.com>
Date:   Sun Oct 13 18:44:10 2013 +0200

    correct example for EDATE function
    
    Change-Id: If081af7b6df824a780fa0fed197416b9403f4231
    Reviewed-on: https://gerrit.libreoffice.org/6239
    Reviewed-by: Andras Timar <andras.timar at collabora.com>
    Tested-by: Andras Timar <andras.timar at collabora.com>

diff --git a/source/text/scalc/01/func_edate.xhp b/source/text/scalc/01/func_edate.xhp
index 7684e70..176438f 100644
--- a/source/text/scalc/01/func_edate.xhp
+++ b/source/text/scalc/01/func_edate.xhp
@@ -33,7 +33,7 @@
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_EDATE" id="bm_id3150761" localize="false"/><paragraph role="heading" id="hd_id3151184" xml-lang="en-US" level="2" l10n="U" oldref="213"><variable id="edate"><link href="text/scalc/01/func_edate.xhp">EDATE</link>
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3150880" xml-lang="en-US" l10n="U" oldref="214"><ahelp hid="HID_AAI_FUNC_EDATE">The result is a date which is a number of m<emph>onths</emph> away from the <emph>start date</emph>. Only months are considered; days are not used for calculation.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3150880" xml-lang="en-US" l10n="U" oldref="214"><ahelp hid="HID_AAI_FUNC_EDATE">The result is a date which is a number of <emph>months</emph> away from the <emph>start date</emph>. Only months are considered; days are not used for calculation.</ahelp></paragraph>
 <paragraph role="heading" id="hd_id3154647" xml-lang="en-US" level="3" l10n="U" oldref="215">Syntax</paragraph>
 <paragraph role="code" id="par_id3153212" xml-lang="en-US" l10n="U" oldref="216">EDATE(StartDate; Months)</paragraph>
 <paragraph role="paragraph" id="par_id3146860" xml-lang="en-US" l10n="U" oldref="217">
@@ -41,8 +41,8 @@
 <paragraph role="paragraph" id="par_id3152929" xml-lang="en-US" l10n="U" oldref="218">
 <emph>Months</emph> is the number of months before (negative) or after (positive) the start date.</paragraph>
 <paragraph role="heading" id="hd_id3151289" xml-lang="en-US" level="3" l10n="U" oldref="219">Example</paragraph>
-<paragraph role="paragraph" id="par_id3155845" xml-lang="en-US" l10n="U" oldref="220">What date is one month prior to 3.31.2001?</paragraph>
+<paragraph role="paragraph" id="par_id3155845" xml-lang="en-US" l10n="U" oldref="220">What date is one month prior to 2001-03-31?</paragraph>
 <paragraph role="paragraph" id="par_id3155999" xml-lang="en-US" l10n="U" oldref="221">
-<item type="input">=EDATE(3.31.2001;-1)</item> returns 2.28.2001.</paragraph>
+<item type="input">=EDATE("2001-03-31";-1)</item> returns the serial number 36950. Formatted as a date, this is 2001-02-28.</paragraph>
 </body>
 </helpdocument>


More information about the Libreoffice-commits mailing list