source/text/scalc/01/04060111.xhp | 17 +++++++++++++----
1 file changed, 13 insertions(+), 4 deletions(-)
New commits:
commit 3cb9f803eae6a60ae6bc8ca35ccd74126f14a871
Author: Rafael Lima <rafael.palma.l...@gmail.com>
AuthorDate: Wed Jan 12 14:02:12 2022 +0100
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Jan 13 12:28:47 2022 +0100
tdf#70551 Improve description of the WEEKS add-in function
Change-Id: Ic4e234496a05fb1e88de88f554a2b5ae90244651
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128331
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060111.xhp
b/source/text/scalc/01/04060111.xhp
index 6b71378b5..a349fc111 100644
--- a/source/text/scalc/01/04060111.xhp
+++ b/source/text/scalc/01/04060111.xhp
@@ -152,18 +152,27 @@
<section id="weeks">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3149048"><bookmark_value>WEEKS function</bookmark_value>
<bookmark_value>number of weeks;between two dates</bookmark_value>
-</bookmark><comment>mw added one entry</comment>
+</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_DAI_FUNC_DIFFWEEKS"
id="bm_id3150435" localize="false"/>
<h2 id="hd_id3149048">WEEKS</h2>
<paragraph role="paragraph" id="par_id3153340" xml-lang="en-US"><ahelp
hid="HID_DAI_FUNC_DIFFWEEKS">Calculates the difference in weeks between two
dates.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3147402" xml-lang="en-US">WEEKS(StartDate;
EndDate; Type)</paragraph>
<paragraph role="paragraph" id="par_id3151387" xml-lang="en-US">
-<emph>StartDate</emph> is the first date</paragraph>
+<emph>StartDate</emph> is the start date in the interval.</paragraph>
<paragraph role="paragraph" id="par_id3146324" xml-lang="en-US">
-<emph>EndDate</emph> is the second date</paragraph>
+<emph>EndDate</emph> is the end date in the interval. The end date must be
greater than the start date, or else an error is returned.</paragraph>
<paragraph role="paragraph" id="par_id3166467" xml-lang="en-US">
-<emph>Type</emph> calculates the type of difference. The possible values are 0
(interval) and 1 (in numbers of weeks).</paragraph>
+<emph>Type</emph> specifies the type of difference to be calculated. Possible
values are 0 (time interval) or 1 (calendar weeks).</paragraph>
+<paragraph role="paragraph" id="par_id81641990941192">If <emph>Type = 0</emph>
the function will assume that 7 days is equivalent to one week without
considering any specific day to mark the begninning of a week.</paragraph>
+<paragraph role="paragraph" id="par_id31641991010650">If <emph>Type = 1</emph>
the function will consider Monday to be the first day of the week. Therefore,
except for the start date, each occurrence of a Monday in the interval is
counted as an additional week.</paragraph>
+<note id="par_id971641990480242">This function considers Monday to be the
first day of the week regardless of the current locale settings.</note>
+<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+<paragraph role="paragraph" id="par_id671641994821992">In the following
examples, dates are passed as strings. However, they can also be stored in
separate cells and be passed as references.</paragraph>
+<paragraph role="paragraph"
id="par_id71641991391639"><input>=WEEKS("01/12/2022","01/17/2022",0)</input>
returns 0 because <emph>Type</emph> was set to 0 and there are only 5 days in
the interval.</paragraph>
+<paragraph role="paragraph"
id="par_id71641991390039"><input>=WEEKS("01/12/2022","01/19/2022",0)</input>
returns 1 because <emph>Type</emph> was set to 0 and there are 7 days in the
interval.</paragraph>
+<paragraph role="paragraph"
id="par_id71641991391123"><input>=WEEKS("01/12/2022","01/17/2022",1)</input>
returns 1 because <emph>Type</emph> was set to 1 and the interval contains a
Monday, since 01/12/2022 is a Wednesday and 01/17/2022 is a Monday.</paragraph>
+<paragraph role="paragraph"
id="par_id71641991332523"><input>=WEEKS("01/10/2022","01/15/2022",1)</input>
returns 0 because <emph>Type</emph> was set to 1 and the interval does not
contain any Mondays, except for the start date.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>ORG.OPENOFFICE.WEEKS</literal></paragraph>
