summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEike Rathke <erack@redhat.com>2016-01-08 11:24:40 +0100
committerMiklos Vajna <vmiklos@collabora.co.uk>2016-01-11 12:46:26 +0000
commitc1ceff53b1e8f453a4451616a1ddcb49460dfca6 (patch)
tree966e5617975fd2e4c90282c0f04bfa32aa25f9f3
parent0cf317ca3a91d1cc87b8079f10a05db1a01d3548 (diff)
tdf#85433 help content for WEEKNUM, ISOWEEKNUM, WEEKNUM_EXCEL2003, WEEKNUM_OOO
Change-Id: I92995b4de6fe18d981757f0d273ddce5c11b1559 (cherry picked from commit 71a3f0e66fb6fb37f73fe3841a36ba00bec5beaa) Reviewed-on: https://gerrit.libreoffice.org/21248 Reviewed-by: Miklos Vajna <vmiklos@collabora.co.uk> Tested-by: Miklos Vajna <vmiklos@collabora.co.uk>
-rw-r--r--AllLangHelp_scalc.mk2
-rw-r--r--source/text/scalc/01/04060102.xhp12
-rw-r--r--source/text/scalc/01/func_isoweeknum.xhp46
-rw-r--r--source/text/scalc/01/func_weeknum.xhp29
-rw-r--r--source/text/scalc/01/func_weeknum_ooo.xhp51
-rw-r--r--source/text/scalc/01/func_weeknumadd.xhp14
6 files changed, 138 insertions, 16 deletions
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 975c527b18..efce3956fe 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -207,6 +207,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_imsin \
helpcontent2/source/text/scalc/01/func_imsinh \
helpcontent2/source/text/scalc/01/func_imtan \
+ helpcontent2/source/text/scalc/01/func_isoweeknum \
helpcontent2/source/text/scalc/01/func_minute \
helpcontent2/source/text/scalc/01/func_month \
helpcontent2/source/text/scalc/01/func_networkdays \
@@ -220,6 +221,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_weekday \
helpcontent2/source/text/scalc/01/func_webservice \
helpcontent2/source/text/scalc/01/func_weeknum \
+ helpcontent2/source/text/scalc/01/func_weeknum_ooo \
helpcontent2/source/text/scalc/01/func_weeknumadd \
helpcontent2/source/text/scalc/01/func_workday \
helpcontent2/source/text/scalc/01/func_year \
diff --git a/source/text/scalc/01/04060102.xhp b/source/text/scalc/01/04060102.xhp
index db41ffd403..9ff462d83a 100644
--- a/source/text/scalc/01/04060102.xhp
+++ b/source/text/scalc/01/04060102.xhp
@@ -38,7 +38,7 @@
<embed href="text/scalc/00/00000404.xhp#eikadaze"/>
</section>
<section id="ADD_note">
-<paragraph role="note" id="par_idN10600" xml-lang="en-US" l10n="NEW">The functions whose names end with _ADD return the same results as the corresponding Microsoft Excel functions. Use the functions without _ADD to get results based on international standards. For example, the WEEKNUM function calculates the week number of a given date based on international standard ISO 8601, while WEEKNUM_ADD returns the same week number as Microsoft Excel.<comment>UFI: see #33784#</comment></paragraph>
+<paragraph role="note" id="par_idN10600" xml-lang="en-US" l10n="NEW">The functions whose names end with _ADD or _EXCEL2003 return the same results as the corresponding Microsoft Excel 2003 functions without the suffix. Use the functions without suffix to get results based on international standards.</paragraph>
</section>
<paragraph role="paragraph" id="par_id3150437" xml-lang="en-US" l10n="U" oldref="170">$[officename] internally handles a date/time value as a numerical value. If you assign the numbering format "Number" to a date or time value, it is converted to a number. For example, 01/01/2000 12:00 PM, converts to 36526.5. The value preceding the decimal point corresponds to the date; the value following the decimal point corresponds to the time. If you do not want to see this type of numerical date or time representation, change the number format (date or time) accordingly. To do this, select the cell containing the date or time value, call its context menu and select <emph>Format Cells</emph>. The <emph>Numbers</emph> tab page contains the functions for defining the number format.</paragraph>
<paragraph role="heading" id="hd_id2408825" xml-lang="en-US" level="2" l10n="NEW">Date base for day zero</paragraph>
@@ -130,11 +130,21 @@
<embedvar href="text/scalc/01/func_now.xhp#now"/>
</paragraph>
</section>
+<section id="isoweeknum">
+<paragraph role="paragraph" id="par_id3886533" xml-lang="en-US" l10n="NEW" localize="false" >
+ <embedvar href="text/scalc/01/func_isoweeknum.xhp#isoweeknum"/>
+</paragraph>
+</section>
<section id="weeknum">
<paragraph role="paragraph" id="par_id3886532" xml-lang="en-US" l10n="NEW" localize="false" >
<embedvar href="text/scalc/01/func_weeknum.xhp#weeknum"/>
</paragraph>
</section>
+<section id="weeknum_ooo">
+<paragraph role="paragraph" id="par_id3886534" xml-lang="en-US" l10n="NEW" localize="false" >
+ <embedvar href="text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo"/>
+</paragraph>
+</section>
<section id="weeknumadd">
<paragraph role="paragraph" id="par_id614947" xml-lang="en-US" l10n="NEW" localize="false" >
<embedvar href="text/scalc/01/func_weeknumadd.xhp#weeknumadd"/>
diff --git a/source/text/scalc/01/func_isoweeknum.xhp b/source/text/scalc/01/func_isoweeknum.xhp
new file mode 100644
index 0000000000..3e283be911
--- /dev/null
+++ b/source/text/scalc/01/func_isoweeknum.xhp
@@ -0,0 +1,46 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+
+ <helpdocument version="1.0">
+<meta>
+<topic id="textscalc01func_isoweeknumxml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">ISOWEEKNUM</title>
+<filename>/text/scalc/01/func_isoweeknum.xhp</filename>
+</topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3159161"><bookmark_value>ISOWEEKNUM function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISOWEEKNUM" id="bm_id3158403" localize="false"/><paragraph role="heading" id="hd_id3159161" xml-lang="en-US" level="2" l10n="NEW" oldref="54"><variable id="isoweeknum"><link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3149770" xml-lang="en-US" l10n="NEW" oldref="55"><ahelp hid="HID_FUNC_ISOWEEKNUM">ISOWEEKNUM calculates the week number of the year for the internal date value.</ahelp></paragraph>
+<paragraph role="note" id="par_idN105E4" xml-lang="en-US" l10n="NEW">The International Standard ISO 8601 has decreed that Monday shall be the first day of the week. A week that lies partly in one year and partly in another is assigned a number in the year in which most of its days lie. That means that week number 1 of any year is the week that contains the January 4th.</paragraph>
+<paragraph role="heading" id="hd_id3153055" xml-lang="en-US" level="3" l10n="NEW" oldref="56">Syntax</paragraph>
+<paragraph role="code" id="par_id3147236" xml-lang="en-US" l10n="NEW" oldref="57">ISOWEEKNUM(Number)</paragraph>
+<paragraph role="paragraph" id="par_id3147511" xml-lang="en-US" l10n="NEW" oldref="58">
+<emph>Number</emph> is the internal date number.</paragraph>
+<paragraph role="heading" id="hd_id3146948" xml-lang="en-US" level="3" l10n="NEW" oldref="62">Examples</paragraph>
+<paragraph role="paragraph" id="par_id3149792" xml-lang="en-US" l10n="NEW" oldref="64">=ISOWEEKNUM(DATE(1995;1;1)) returns 52. Week 1 starts on Monday, 1995-01-02.</paragraph>
+<paragraph role="paragraph" id="par_id3149794" xml-lang="en-US" l10n="NEW" oldref="67">=ISOWEEKNUM(DATE(1999;1;1)) returns 53. Week 1 starts on Monday, 1999-01-04.</paragraph>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_weeknum.xhp b/source/text/scalc/01/func_weeknum.xhp
index 58d1f9346d..a19848ff15 100644
--- a/source/text/scalc/01/func_weeknum.xhp
+++ b/source/text/scalc/01/func_weeknum.xhp
@@ -33,18 +33,31 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KALENDERWOCHE" id="bm_id3158403" localize="false"/><paragraph role="heading" id="hd_id3159161" xml-lang="en-US" level="2" l10n="U" oldref="54"><variable id="weeknum"><link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3149770" xml-lang="en-US" l10n="U" oldref="55"><ahelp hid="HID_FUNC_KALENDERWOCHE">WEEKNUM calculates the week number of the year for the internal date value.</ahelp></paragraph>
-<paragraph role="note" id="par_idN105E4" xml-lang="en-US" l10n="NEW">The International Standard ISO 8601 has decreed that Monday shall be the first day of the week. A week that lies partly in one year and partly in another is assigned a number in the year in which most of its days lie. That means that week number 1 of any year is the week that contains the January 4th.</paragraph>
+<paragraph role="paragraph" id="par_id3149770" xml-lang="en-US" l10n="CHG" oldref="55"><ahelp hid="HID_FUNC_KALENDERWOCHE">WEEKNUM calculates the week number of the year for the internal date value as defined in ODF OpenFormula and compatible with other spreadsheet applications.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3147220" xml-lang="en-US" l10n="NEW">Supported are two week numbering systems:</paragraph>
+<paragraph role="paragraph" id="par_id3147221" xml-lang="en-US" l10n="NEW">System 1: The week containing January 1 is the first week of the year, and is numbered week 1.</paragraph>
+<paragraph role="paragraph" id="par_id3147222" xml-lang="en-US" l10n="NEW">System 2: The week containing the first Thursday of the year is the first week of the year, and is numbered week 1. That means that week number 1 of any year is the week that contains January 4th. ISO 8601 defines this system and that the week starts on Monday.</paragraph>
<paragraph role="heading" id="hd_id3153055" xml-lang="en-US" level="3" l10n="U" oldref="56">Syntax</paragraph>
-<paragraph role="code" id="par_id3147236" xml-lang="en-US" l10n="U" oldref="57">WEEKNUM(Number; Mode)</paragraph>
+<paragraph role="code" id="par_id3147236" xml-lang="en-US" l10n="CHG" oldref="57">WEEKNUM(Number [; Mode])</paragraph>
<paragraph role="paragraph" id="par_id3147511" xml-lang="en-US" l10n="U" oldref="58">
<emph>Number</emph> is the internal date number.</paragraph>
<paragraph role="paragraph" id="par_id3154269" xml-lang="en-US" l10n="U" oldref="59">
-<emph>Mode</emph> sets the start of the week and the calculation type.</paragraph>
-<paragraph role="paragraph" id="par_id3148930" xml-lang="en-US" l10n="U" oldref="60">1 = Sunday</paragraph>
-<paragraph role="paragraph" id="par_id3154280" xml-lang="en-US" l10n="U" oldref="61">2 = Monday</paragraph>
+<emph>Mode</emph> sets the start of the week and the week numbering system. This parameter is optional, if omitted the default value is 1.</paragraph>
+<paragraph role="paragraph" id="par_id3148930" xml-lang="en-US" l10n="NEW" oldref="60">1 = Sunday, system 1</paragraph>
+<paragraph role="paragraph" id="par_id3154280" xml-lang="en-US" l10n="NEW" oldref="61">2 = Monday, system 1</paragraph>
+<paragraph role="paragraph" id="par_id3154281" xml-lang="en-US" l10n="NEW" oldref="71">11 = Monday, system 1</paragraph>
+<paragraph role="paragraph" id="par_id3154282" xml-lang="en-US" l10n="NEW" oldref="72">12 = Tuesday, system 1</paragraph>
+<paragraph role="paragraph" id="par_id3154283" xml-lang="en-US" l10n="NEW" oldref="73">13 = Wednesday, system 1</paragraph>
+<paragraph role="paragraph" id="par_id3154284" xml-lang="en-US" l10n="NEW" oldref="74">14 = Thursday, system 1</paragraph>
+<paragraph role="paragraph" id="par_id3154285" xml-lang="en-US" l10n="NEW" oldref="75">15 = Friday, system 1</paragraph>
+<paragraph role="paragraph" id="par_id3154286" xml-lang="en-US" l10n="NEW" oldref="76">16 = Saturday, system 1</paragraph>
+<paragraph role="paragraph" id="par_id3154287" xml-lang="en-US" l10n="NEW" oldref="77">17 = Sunday, system 1</paragraph>
+<paragraph role="paragraph" id="par_id3154288" xml-lang="en-US" l10n="NEW" oldref="81">21 = Monday, system 2 (ISO 8601)</paragraph>
+<paragraph role="paragraph" id="par_id3154289" xml-lang="en-US" l10n="NEW" oldref="110">150 = Monday, system 2 (ISO 8601, for interoperability with Gnumeric)</paragraph>
<paragraph role="heading" id="hd_id3146948" xml-lang="en-US" level="3" l10n="U" oldref="62">Examples</paragraph>
-<paragraph role="paragraph" id="par_id3150704" xml-lang="en-US" l10n="CHG" oldref="65">=WEEKNUM("1995-01-01";1) returns 1</paragraph>
-<paragraph role="paragraph" id="par_id3149792" xml-lang="en-US" l10n="CHG" oldref="64">=WEEKNUM("1995-01-01";2) returns 52. If the week starts on Monday, Sunday belongs to the last week of the previous year.</paragraph>
+<paragraph role="paragraph" id="par_id3150704" xml-lang="en-US" l10n="CHG" oldref="65">=WEEKNUM(DATE(1995;1;1);1) returns 1</paragraph>
+<paragraph role="paragraph" id="par_id3149792" xml-lang="en-US" l10n="CHG" oldref="64">=WEEKNUM(DATE(1995;1;1);2) returns 52. If the week starts on Monday, Sunday belongs to the last week of the previous year.</paragraph>
+<paragraph role="paragraph" id="par_id3149793" xml-lang="en-US" l10n="NEW" oldref="66">=WEEKNUM(DATE(1995;1;1);21) returns 52. Week 1 starts on Monday, 1995-01-02.</paragraph>
+<paragraph role="paragraph" id="par_id3149794" xml-lang="en-US" l10n="NEW" oldref="67">=WEEKNUM(DATE(1999;1;1);21) returns 53. Week 1 starts on Monday, 1999-01-04.</paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_weeknum_ooo.xhp b/source/text/scalc/01/func_weeknum_ooo.xhp
new file mode 100644
index 0000000000..bbc14b6b11
--- /dev/null
+++ b/source/text/scalc/01/func_weeknum_ooo.xhp
@@ -0,0 +1,51 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+
+ <helpdocument version="1.0">
+<meta>
+<topic id="textscalc01func_weeknum_oooxml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">WEEKNUM_OOO</title>
+<filename>/text/scalc/01/func_weeknum_ooo.xhp</filename>
+</topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3159161"><bookmark_value>WEEKNUM_OOO function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEEKNUM_OOO" id="bm_id3158403" localize="false"/><paragraph role="heading" id="hd_id3159161" xml-lang="en-US" level="2" l10n="NEW" oldref="54"><variable id="weeknum_ooo"><link href="text/scalc/01/func_weeknum_ooo.xhp">WEEKNUM_OOO</link>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3149770" xml-lang="en-US" l10n="NEW" oldref="55"><ahelp hid="HID_FUNC_WEEKNUM_OOO">WEEKNUM_OOO calculates the week number of the year for the internal date value.</ahelp></paragraph>
+<paragraph role="note" id="par_idN105E4" xml-lang="en-US" l10n="NEW">This function exists for interoperability with LibreOffice releases older than 5.1.0 and OpenOffice.org. It calculates week numbers for a week numbering system in that week number 1 is the week that contains the January 4th. This function does not provide interoperability with other spreadsheet applications. For new documents use the <link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> or <link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link> function instead.</paragraph>
+<paragraph role="heading" id="hd_id3153055" xml-lang="en-US" level="3" l10n="NEW" oldref="56">Syntax</paragraph>
+<paragraph role="code" id="par_id3147236" xml-lang="en-US" l10n="CHG" oldref="57">WEEKNUM_OOO(Number; Mode)</paragraph>
+<paragraph role="paragraph" id="par_id3147511" xml-lang="en-US" l10n="U" oldref="58">
+<emph>Number</emph> is the internal date number.</paragraph>
+<paragraph role="paragraph" id="par_id3154269" xml-lang="en-US" l10n="U" oldref="59">
+<emph>Mode</emph> sets the start of the week and the calculation type.</paragraph>
+<paragraph role="paragraph" id="par_id3148930" xml-lang="en-US" l10n="U" oldref="60">1 = Sunday</paragraph>
+<paragraph role="paragraph" id="par_id3154280" xml-lang="en-US" l10n="CHG" oldref="61">2 = Monday (ISO 8601)</paragraph>
+<paragraph role="paragraph" id="par_id3154281" xml-lang="en-US" l10n="NEW" oldref="66">any other value = Monday (ISO 8601)</paragraph>
+<paragraph role="heading" id="hd_id3146948" xml-lang="en-US" level="3" l10n="U" oldref="62">Examples</paragraph>
+<paragraph role="paragraph" id="par_id3150704" xml-lang="en-US" l10n="CHG" oldref="65">=WEEKNUM_OOO(DATE(1995;1;1);1) returns 1</paragraph>
+<paragraph role="paragraph" id="par_id3149792" xml-lang="en-US" l10n="CHG" oldref="64">=WEEKNUM_OOO(DATE(1995;1;1);2) returns 52. Week 1 starts on Monday, 1995-01-02.</paragraph>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_weeknumadd.xhp b/source/text/scalc/01/func_weeknumadd.xhp
index 4c46437777..de257e6a06 100644
--- a/source/text/scalc/01/func_weeknumadd.xhp
+++ b/source/text/scalc/01/func_weeknumadd.xhp
@@ -24,26 +24,26 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_weeknumaddxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">WEEKNUM_ADD </title>
+<title id="tit" xml-lang="en-US">WEEKNUM_EXCEL2003 </title>
<filename>/text/scalc/01/func_weeknumadd.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3166443"><bookmark_value>WEEKNUM_ADD function</bookmark_value>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3166443"><bookmark_value>WEEKNUM_EXCEL2003 function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_WEEKNUM" id="bm_id3166454" localize="false"/><paragraph role="heading" id="hd_id3166443" xml-lang="en-US" level="2" l10n="U" oldref="222"><variable id="weeknumadd"><link href="text/scalc/01/func_weeknumadd.xhp">WEEKNUM_ADD</link>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_WEEKNUM" id="bm_id3166454" localize="false"/><paragraph role="heading" id="hd_id3166443" xml-lang="en-US" level="2" l10n="U" oldref="222"><variable id="weeknumadd"><link href="text/scalc/01/func_weeknumadd.xhp">WEEKNUM_EXCEL2003</link>
</variable></paragraph>
<paragraph role="paragraph" id="par_id3152945" xml-lang="en-US" l10n="U" oldref="223"><ahelp hid="HID_AAI_FUNC_WEEKNUM">The result indicates the number of the calendar week for a date.</ahelp></paragraph>
-<paragraph role="tip" id="par_idN105DD" xml-lang="en-US" l10n="NEW">The WEEKNUM_ADD function is designed to calculate week numbers exactly as Microsoft Excel does. Use the <link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> function, or format your date cells using the WW formatting code, when you need ISO 8601 week numbers.</paragraph>
+<paragraph role="tip" id="par_idN105DD" xml-lang="en-US" l10n="NEW">The WEEKNUM_EXCEL2003 function is designed to calculate week numbers exactly as Microsoft Excel 2003 did. Use the <link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> function for ODF OpenFormula and Excel 2010 compatibility, or <link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link> function when you just need ISO 8601 week numbers. In releases prior to $[officename] 5.1 WEEKNUM_EXCEL2003 was named WEEKNUM_ADD.</paragraph>
<paragraph role="heading" id="hd_id3153745" xml-lang="en-US" level="3" l10n="U" oldref="224">Syntax</paragraph>
-<paragraph role="code" id="par_id3153685" xml-lang="en-US" l10n="U" oldref="225">WEEKNUM_ADD(Date; ReturnType)</paragraph>
+<paragraph role="code" id="par_id3153685" xml-lang="en-US" l10n="U" oldref="225">WEEKNUM_EXCEL2003(Date; ReturnType)</paragraph>
<paragraph role="paragraph" id="par_id3159277" xml-lang="en-US" l10n="U" oldref="226">
<emph>Date</emph> is the date within the calendar week.</paragraph>
<paragraph role="paragraph" id="par_id3154098" xml-lang="en-US" l10n="U" oldref="227">
<emph>ReturnType</emph> is 1 for week beginning on a Sunday, 2 for week beginning on a Monday.</paragraph>
<paragraph role="heading" id="hd_id3152886" xml-lang="en-US" level="3" l10n="U" oldref="228">Example</paragraph>
-<paragraph role="paragraph" id="par_id3149973" xml-lang="en-US" l10n="U" oldref="229">In which week number does 12.24.2001 fall?</paragraph>
+<paragraph role="paragraph" id="par_id3149973" xml-lang="en-US" l10n="U" oldref="229">In which week number does 12/24/2001 fall?</paragraph>
<paragraph role="paragraph" id="par_id3149914" xml-lang="en-US" l10n="U" oldref="230">
-<item type="input">=WEEKNUM_ADD(24.12.2001;1)</item> returns 52.</paragraph>
+<item type="input">=WEEKNUM_EXCEL2003(DATE(2001;12;24);1)</item> returns 52.</paragraph>
</body>
</helpdocument>