diff options
| author | Andreas Heinisch <andreas.heinisch@yahoo.de> | 2021-04-19 07:54:12 +0200 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2021-04-20 11:11:01 +0200 |
| commit | 1cb52499d411fbef66b0b0fa50096f9896938acc (patch) | |
| tree | 84296247a4474c7289ef80c0522e3a192bb44b67 | |
| parent | 72ea0527c004c8dc96aa05b02037cdc80e5f0e1a (diff) | |
tdf#100070 - Corrected example for WEEKNUM using System 1
Change-Id: Ie659fa5dbc9dcd4cb5c3b4d6b15a6b045a3cf36e
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/114187
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
| -rw-r--r-- | source/text/scalc/01/func_weeknum.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/func_weeknum.xhp b/source/text/scalc/01/func_weeknum.xhp index a23d5cdf50..99a089af3d 100644 --- a/source/text/scalc/01/func_weeknum.xhp +++ b/source/text/scalc/01/func_weeknum.xhp @@ -174,7 +174,7 @@ <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3150704" xml-lang="en-US"><item type="input">=WEEKNUM(DATE(1995;1;1);1)</item> returns 1</paragraph> -<paragraph role="paragraph" id="par_id3149792" xml-lang="en-US"><item type="input">=WEEKNUM(DATE(1995;1;1);2)</item> returns 52. If the week starts on Monday, Sunday belongs to the last week of the previous year.</paragraph> +<paragraph role="paragraph" id="par_id3149792" xml-lang="en-US"><item type="input">=WEEKNUM(DATE(1995;1;1);2)</item> returns 1. Using System 1, the week containing January 1 is the first week of the year.</paragraph> <paragraph role="paragraph" id="par_id3149793" xml-lang="en-US"><item type="input">=WEEKNUM(DATE(1995;1;1);21)</item> returns 52. Week 1 starts on Monday, 1995-01-02.</paragraph> <paragraph role="paragraph" id="par_id3149794" xml-lang="en-US"><item type="input">=WEEKNUM(DATE(1999;1;1);21)</item> returns 53. Week 1 starts on Monday, 1999-01-04.</paragraph> <section id="relatedtopics"> |