[Libreoffice-commits] help.git: source/text
Olivier Hallot (via logerrit)
logerrit at kemper.freedesktop.org
Sun Dec 29 10:22:38 UTC 2019
source/text/scalc/01/04060102.xhp | 127 ++++---------------------
source/text/scalc/01/func_date.xhp | 15 +-
source/text/scalc/01/func_datedif.xhp | 11 +-
source/text/scalc/01/func_datevalue.xhp | 8 +
source/text/scalc/01/func_day.xhp | 9 +
source/text/scalc/01/func_days.xhp | 8 +
source/text/scalc/01/func_days360.xhp | 8 +
source/text/scalc/01/func_eastersunday.xhp | 7 -
source/text/scalc/01/func_edate.xhp | 15 +-
source/text/scalc/01/func_eomonth.xhp | 16 +--
source/text/scalc/01/func_hour.xhp | 17 +--
source/text/scalc/01/func_isoweeknum.xhp | 17 +--
source/text/scalc/01/func_minute.xhp | 15 +-
source/text/scalc/01/func_month.xhp | 8 +
source/text/scalc/01/func_networkdays.intl.xhp | 5
source/text/scalc/01/func_networkdays.xhp | 7 -
source/text/scalc/01/func_now.xhp | 15 +-
source/text/scalc/01/func_second.xhp | 15 +-
source/text/scalc/01/func_time.xhp | 15 +-
source/text/scalc/01/func_timevalue.xhp | 8 +
source/text/scalc/01/func_today.xhp | 15 +-
source/text/scalc/01/func_weekday.xhp | 13 +-
source/text/scalc/01/func_weeknum.xhp | 38 ++++---
source/text/scalc/01/func_weeknum_ooo.xhp | 9 +
source/text/scalc/01/func_weeknumadd.xhp | 16 +--
source/text/scalc/01/func_workday.intl.xhp | 5
source/text/scalc/01/func_workday.xhp | 11 --
source/text/scalc/01/func_year.xhp | 19 +--
source/text/scalc/01/func_yearfrac.xhp | 37 +++----
29 files changed, 218 insertions(+), 291 deletions(-)
New commits:
commit efc2eba6081f95dbf83ea1776a563bbddaa13f68
Author: Olivier Hallot <olivier.hallot at libreoffice.org>
AuthorDate: Sat Dec 28 13:52:39 2019 -0300
Commit: Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Sun Dec 29 11:22:16 2019 +0100
tdf#127477 Incomplete description of date & time
functions
+ case of YEAR()
+ some refactoring
+ mention ODFF standard where it applies.
Change-Id: I91c2a7f8cc799d99af8380f228678ef0e49bdd83
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/85926
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>
diff --git a/source/text/scalc/01/04060102.xhp b/source/text/scalc/01/04060102.xhp
index 3f0acce19..2e1fd1799 100644
--- a/source/text/scalc/01/04060102.xhp
+++ b/source/text/scalc/01/04060102.xhp
@@ -26,15 +26,12 @@
</meta>
<body>
-
<bookmark xml-lang="en-US" branch="index" id="bm_id3154536">
<bookmark_value>date and time functions</bookmark_value>
<bookmark_value>functions; date & time</bookmark_value>
<bookmark_value>Function Wizard; date & time</bookmark_value>
</bookmark>
-
-
-<h1 id="hd_id3154536">Date & Time Functions</h1>
+<h1 id="hd_id3154536"><variable id="h1">Date & Time Functions</variable></h1>
<paragraph id="par_id3153973" role="paragraph" xml-lang="en-US"><variable id="datumzeittext">These spreadsheet functions are used for inserting and editing dates and times. </variable></paragraph>
<section id="howtoget">
@@ -46,6 +43,7 @@
</section>
<paragraph id="par_id3150437" role="paragraph" xml-lang="en-US">$[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>
+<section id="datebase">
<h2 id="hd_id2408825">Date base for day zero</h2>
<paragraph id="par_id9988402" role="paragraph" xml-lang="en-US">Dates are calculated as offsets from a starting day zero. You can set the day zero to be one of the following:</paragraph>
@@ -83,7 +81,7 @@
</tablecell>
</tablerow>
</table>
-
+</section>
<paragraph id="par_id791039" role="paragraph" xml-lang="en-US">Choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph>
</caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Calculate</emph> to select the date base.</paragraph>
<warning id="par_id1953489">When you copy and paste cells containing date values between different spreadsheets, both spreadsheet documents must be set to the same date base. If date bases differ, the displayed date values will change!</warning>
@@ -101,124 +99,41 @@
<note id="par_id651547654187646">Time zone information is not used in Date and Time functions and cells.</note>
<h2 id="par_idN1067A">Functions</h2>
-<sort order="asc">
-
-<section id="workday">
-<paragraph id="par_idN10683" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_workday.xhp#workday"/> </paragraph>
-</section>
-
-<section id="yearfrac">
-<paragraph id="par_id5189062" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_yearfrac.xhp#yearfrac"/> </paragraph>
-</section>
+<section id="datetimefunctions">
+ <paragraph role="paragraph" id="par_id31577531529079" localize="false"><embedvar href="text/scalc/01/04060102.xhp#h1" markup="ignore"/></paragraph>
-<section id="date">
<paragraph id="par_id6854457" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_date.xhp#date"/> </paragraph>
-</section>
-
-<section id="datedif">
<paragraph id="par_id6354457" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_datedif.xhp#datedif"/> </paragraph>
-</section>
-
-<section id="datevalue">
<paragraph id="par_id3372295" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_datevalue.xhp#datevalue"/> </paragraph>
-</section>
-
-<section id="edate">
+<paragraph id="par_id5375835" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_day.xhp#day"/> </paragraph>
+<paragraph id="par_id1208838" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_days.xhp#days"/> </paragraph>
+<paragraph id="par_id7679982" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_days360.xhp#days360"/> </paragraph>
+<paragraph id="par_id1074251" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_eastersunday.xhp#eastersunday"/> </paragraph>
<paragraph id="par_id5684377" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_edate.xhp#edate"/> </paragraph>
-</section>
-
-<section id="today">
-<paragraph id="par_id7576525" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_today.xhp#today"/> </paragraph>
-</section>
-
-<section id="year">
-<paragraph id="par_id641193" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_year.xhp#year"/> </paragraph>
-</section>
-
-<section id="now">
-<paragraph id="par_id6501968" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_now.xhp#now"/> </paragraph>
-</section>
-
-<section id="isoweeknum">
+<paragraph id="par_id1346781" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_eomonth.xhp#eomonth"/> </paragraph>
+<paragraph id="par_id224005" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_hour.xhp#hour"/> </paragraph>
<paragraph id="par_id3886533" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_isoweeknum.xhp#isoweeknum"/> </paragraph>
-</section>
-
-<section id="weeknum">
-<paragraph id="par_id3886532" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weeknum.xhp#weeknum"/> </paragraph>
-</section>
-
-<section id="weeknum_ooo">
-<paragraph id="par_id3886534" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo"/> </paragraph>
-</section>
-
-<section id="weeknumadd">
-<paragraph id="par_id614947" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weeknumadd.xhp#weeknumadd"/> </paragraph>
-</section>
-
-<section id="minute">
<paragraph id="par_id3953062" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_minute.xhp#minute"/> </paragraph>
-</section>
-
-<section id="month">
<paragraph id="par_id2579729" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_month.xhp#month"/> </paragraph>
-</section>
-
-<section id="eomonth">
-<paragraph id="par_id1346781" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_eomonth.xhp#eomonth"/> </paragraph>
-</section>
-
-<section id="networkdays">
<paragraph id="par_id8951384" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_networkdays.xhp#networkdays"/> </paragraph>
-</section>
-
-<section id="networkdaysintl">
<paragraph id="par_id231020162315043955" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_networkdays.intl.xhp#networkdaysintl"/> </paragraph>
-</section>
-
-<section id="workdaysintl">
-<paragraph id="par_id231020163315043955" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_workday.intl.xhp#workdaysintl"/> </paragraph>
-</section>
-
-<section id="eastersunday">
-<paragraph id="par_id1074251" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_eastersunday.xhp#eastersunday"/> </paragraph>
-</section>
-
-<section id="second">
+<paragraph id="par_id6501968" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_now.xhp#now"/> </paragraph>
<paragraph id="par_id372325" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_second.xhp#second"/> </paragraph>
-</section>
-
-<section id="hour">
-<paragraph id="par_id224005" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_hour.xhp#hour"/> </paragraph>
-</section>
-
-<section id="day">
-<paragraph id="par_id5375835" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_day.xhp#day"/> </paragraph>
-</section>
-
-<section id="days">
-<paragraph id="par_id1208838" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_days.xhp#days"/> </paragraph>
-</section>
-
-<section id="days360">
-<paragraph id="par_id7679982" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_days360.xhp#days360"/> </paragraph>
-</section>
-
-<section id="weekday">
-<paragraph id="par_id9172643" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weekday.xhp#weekday"/> </paragraph>
-</section>
-
-<section id="time">
<paragraph id="par_id2354503" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_time.xhp#time"/> </paragraph>
-</section>
-
-<section id="timevalue">
<paragraph id="par_id7765434" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_timevalue.xhp#timevalue"/> </paragraph>
+<paragraph id="par_id7576525" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_today.xhp#today"/> </paragraph>
+<paragraph id="par_id9172643" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weekday.xhp#weekday"/> </paragraph>
+<paragraph id="par_id3886532" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weeknum.xhp#weeknum"/> </paragraph>
+<paragraph id="par_id614947" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weeknumadd.xhp#weeknumadd"/> </paragraph>
+<paragraph id="par_id3886534" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo"/> </paragraph>
+<paragraph id="par_idN10683" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_workday.xhp#workday"/> </paragraph>
+<paragraph id="par_id231020163315043955" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_workday.intl.xhp#workdaysintl"/> </paragraph>
+<paragraph id="par_id641193" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_year.xhp#year"/> </paragraph>
+<paragraph id="par_id5189062" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_yearfrac.xhp#yearfrac"/> </paragraph>
</section>
-</sort>
<section id="relatedtopics">
<embed href="text/scalc/01/04060100.xhp#drking"/>
</section>
</body>
-
</helpdocument>
diff --git a/source/text/scalc/01/func_date.xhp b/source/text/scalc/01/func_date.xhp
index 7ab7182e1..bb05e1f80 100644
--- a/source/text/scalc/01/func_date.xhp
+++ b/source/text/scalc/01/func_date.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_datexml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">DATE</title>
@@ -31,9 +26,10 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3155511"><bookmark_value>DATE function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATUM" id="bm_id3149022" localize="false"/><paragraph role="heading" id="hd_id3155511" xml-lang="en-US" level="2"><variable id="date"><link href="text/scalc/01/func_date.xhp">DATE</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATUM" id="bm_id3149022" localize="false"/><h2 id="hd_id3155511"><variable id="date"><link href="text/scalc/01/func_date.xhp">DATE</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3153551" xml-lang="en-US"><ahelp hid="HID_FUNC_DATUM">This function calculates a date specified by year, month, day and displays it in the cell's formatting.</ahelp> The default format of a cell containing the DATE function is the date format, but you can format the cells with any other number format.</paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3150474" xml-lang="en-US">DATE(Year; Month; Day)</paragraph>
<paragraph role="paragraph" id="par_id3152815" xml-lang="en-US">
@@ -47,5 +43,8 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3152589" xml-lang="en-US">
<item type="input">=DATE(00;1;31)</item> yields 1/31/00 if the cell format setting is MM/DD/YY.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_datedif.xhp b/source/text/scalc/01/func_datedif.xhp
index 3d56e4a28..d6a1cb465 100644
--- a/source/text/scalc/01/func_datedif.xhp
+++ b/source/text/scalc/01/func_datedif.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -20,10 +17,11 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3155511"><bookmark_value>DATEDIF function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATEDIF" id="bm_id3149022" localize="false"/><paragraph role="heading" id="hd_id3155511" xml-lang="en-US" level="2"><variable id="datedif"><link href="text/scalc/01/func_datedif.xhp">DATEDIF</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATEDIF" id="bm_id3149022" localize="false"/><h2 id="hd_id3155511"><variable id="datedif"><link href="text/scalc/01/func_datedif.xhp">DATEDIF</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3153551" xml-lang="en-US"><ahelp hid="HID_FUNC_DATEDIF">This function returns the number of whole days, months or years between Start date and End date.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#3.6"/>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3150474" xml-lang="en-US">DATEDIF(Start date; End date; Interval)</paragraph>
<paragraph role="paragraph" id="par_id3152815" xml-lang="en-US">
@@ -106,5 +104,8 @@ Birthday calculation. A man was born on 1974-04-17. Today is 2012-06-13.</paragr
<item type="input">=DATEDIF("1974-04-17";"2012-06-13";"d")</item> yields 13937, he has been living for 13937 days.</paragraph>
<paragraph role="paragraph" id="par_id3752589" xml-lang="en-US">
<item type="input">=DATEDIF("1974-04-17";DATE(2012;06;13);"yd")</item> yields 57, his birthday was 57 days ago.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_datevalue.xhp b/source/text/scalc/01/func_datevalue.xhp
index 06d27a094..ea24c23be 100644
--- a/source/text/scalc/01/func_datevalue.xhp
+++ b/source/text/scalc/01/func_datevalue.xhp
@@ -30,11 +30,12 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3145621"><bookmark_value>DATEVALUE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATWERT" id="bm_id3163820" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145621" role="heading" level="2"><variable id="datevalue"><link href="text/scalc/01/func_datevalue.xhp">DATEVALUE</link>
-</variable></paragraph>
+<h2 id="hd_id3145621"><variable id="datevalue"><link href="text/scalc/01/func_datevalue.xhp">DATEVALUE</link>
+</variable></h2>
<paragraph xml-lang="en-US" id="par_id3145087" role="paragraph"><ahelp hid="HID_FUNC_DATWERT">Returns the internal date number for text in quotes.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id3149281" role="paragraph">The internal date number is returned as a number. The number is determined by the date system that is used by $[officename] to calculate dates.</paragraph>
<paragraph xml-lang="en-US" id="par_id0119200903491982" role="paragraph">If the text string also includes a time value, DATEVALUE only returns the integer part of the conversion.</paragraph>
+ <embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149268" role="code">DATEVALUE("Text")</paragraph>
<paragraph xml-lang="en-US" id="par_id3154819" role="paragraph">
@@ -44,5 +45,8 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3155841" role="paragraph">
<item type="input">=DATEVALUE("1954-07-20")</item> yields 19925.</paragraph>
+ <section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_day.xhp b/source/text/scalc/01/func_day.xhp
index c9f2c07e8..33804020e 100644
--- a/source/text/scalc/01/func_day.xhp
+++ b/source/text/scalc/01/func_day.xhp
@@ -1,5 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
<!--
* This file is part of the LibreOffice project.
*
@@ -27,9 +26,10 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3147317"><bookmark_value>DAY function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAG" id="bm_id3151283" localize="false"/><paragraph role="heading" id="hd_id3147317" xml-lang="en-US" level="2"><variable id="day"><link href="text/scalc/01/func_day.xhp">DAY</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAG" id="bm_id3151283" localize="false"/><h2 id="hd_id3147317"><variable id="day"><link href="text/scalc/01/func_day.xhp">DAY</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3147584" xml-lang="en-US"><ahelp hid="HID_FUNC_TAG">Returns the day of given date value.</ahelp> The day is returned as an integer between 1 and 31. You can also enter a negative date/time value.</paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3149430" xml-lang="en-US">DAY(Number)</paragraph>
<paragraph role="paragraph" id="par_id3149443" xml-lang="en-US"><emph>Number</emph> is the internal date number.</paragraph>
@@ -39,5 +39,8 @@
<paragraph role="paragraph" id="par_id3151200" xml-lang="en-US"><item type="input">=DAY(1)</item> returns 31 (since $[officename] starts counting at zero from December 30, 1899)</paragraph>
<paragraph role="paragraph" id="par_id3154130" xml-lang="en-US"><item type="input">=DAY(NOW())</item> returns the current day.</paragraph>
<paragraph role="paragraph" id="par_id3159190" xml-lang="en-US"><item type="input">=DAY(C4)</item> returns 5 if you enter 1901-08-05 in cell C4 (the date value might get formatted differently after you press Enter).</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_days.xhp b/source/text/scalc/01/func_days.xhp
index bb002c1a4..fb50701a7 100644
--- a/source/text/scalc/01/func_days.xhp
+++ b/source/text/scalc/01/func_days.xhp
@@ -26,9 +26,10 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3151328"><bookmark_value>DAYS function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAGE" id="bm_id3148893" localize="false"/><paragraph role="heading" id="hd_id3151328" xml-lang="en-US" level="2"><variable id="days"><link href="text/scalc/01/func_days.xhp">DAYS</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAGE" id="bm_id3148893" localize="false"/><h2 id="hd_id3151328"><variable id="days"><link href="text/scalc/01/func_days.xhp">DAYS</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3155139" xml-lang="en-US"><ahelp hid="HID_FUNC_TAGE">Calculates the difference between two date values.</ahelp> The result returns the number of days between the two days.</paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3149578" xml-lang="en-US">DAYS(Date2; Date1)</paragraph>
<paragraph role="paragraph" id="par_id3151376" xml-lang="en-US">
@@ -38,5 +39,8 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3159101" xml-lang="en-US"><item type="input">=DAYS(NOW();"2010-01-01"))</item> returns the number of days from January 1, 2010 until today.</paragraph>
<paragraph role="paragraph" id="par_id3163720" xml-lang="en-US"><item type="input">=DAYS("1990-10-10";"1980-10-10")</item> returns 3652 days.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_days360.xhp b/source/text/scalc/01/func_days360.xhp
index 15d822e90..22f5a3e5a 100644
--- a/source/text/scalc/01/func_days360.xhp
+++ b/source/text/scalc/01/func_days360.xhp
@@ -26,9 +26,10 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3148555"><bookmark_value>DAYS360 function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAGE360" id="bm_id3155906" localize="false"/><paragraph role="heading" id="hd_id3148555" xml-lang="en-US" level="2"><variable id="days360"><link href="text/scalc/01/func_days360.xhp">DAYS360</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAGE360" id="bm_id3155906" localize="false"/><h2 id="hd_id3148555"><variable id="days360"><link href="text/scalc/01/func_days360.xhp">DAYS360</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3156032" xml-lang="en-US"><ahelp hid="HID_FUNC_TAGE360">Returns the difference between two dates based on the 360 day year used in interest calculations.</ahelp></paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3155313" xml-lang="en-US">DAYS360("Date1"; "Date2"; Type)</paragraph>
<paragraph role="paragraph" id="par_id3145263" xml-lang="en-US">If <emph>Date2</emph> is earlier than <emph>Date1</emph>, the function will return a negative number.</paragraph>
@@ -37,5 +38,8 @@
<embed href="text/scalc/01/04060102.xhp#datenumberwarn"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3156348" xml-lang="en-US"><item type="input">=DAYS360("2000-01-01";NOW())</item> returns the number of interest days from January 1, 2000 until today.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_eastersunday.xhp b/source/text/scalc/01/func_eastersunday.xhp
index 9da7e92bc..5cb4fe7de 100644
--- a/source/text/scalc/01/func_eastersunday.xhp
+++ b/source/text/scalc/01/func_eastersunday.xhp
@@ -26,8 +26,8 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3152960"><bookmark_value>EASTERSUNDAY function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_OSTERSONNTAG" id="bm_id3156270" localize="false"/><paragraph role="heading" id="hd_id3152960" xml-lang="en-US" level="2"><variable id="eastersunday"><link href="text/scalc/01/func_eastersunday.xhp">EASTERSUNDAY</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_OSTERSONNTAG" id="bm_id3156270" localize="false"/><h2 id="hd_id3152960"><variable id="eastersunday"><link href="text/scalc/01/func_eastersunday.xhp">EASTERSUNDAY</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3154570" xml-lang="en-US"><ahelp hid="HID_FUNC_OSTERSONNTAG">Returns the date of Easter Sunday for the entered year.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id2113711" xml-lang="en-US">EASTERSUNDAY(Year)</paragraph>
@@ -40,5 +40,8 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3154472" xml-lang="en-US"><item type="input">=EASTERSUNDAY(2000)</item> returns 2000-04-23.</paragraph>
<paragraph role="paragraph" id="par_id3150940" xml-lang="en-US"><item type="input">=EASTERSUNDAY(2000)+49</item> returns the internal serial number 36688. The result is 2000-06-11. Format the serial date number as a date, for example in the format YYYY-MM-DD.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_edate.xhp b/source/text/scalc/01/func_edate.xhp
index 8cc684649..14b050236 100644
--- a/source/text/scalc/01/func_edate.xhp
+++ b/source/text/scalc/01/func_edate.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_edatexml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">EDATE</title>
@@ -31,9 +26,10 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3151184"><bookmark_value>EDATE function</bookmark_value>
</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"><variable id="edate"><link href="text/scalc/01/func_edate.xhp">EDATE</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_EDATE" id="bm_id3150761" localize="false"/><h2 id="hd_id3151184"><variable id="edate"><link href="text/scalc/01/func_edate.xhp">EDATE</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3150880" xml-lang="en-US"><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>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3153212" xml-lang="en-US">EDATE(StartDate; Months)</paragraph>
<paragraph role="paragraph" id="par_id3146860" xml-lang="en-US">
@@ -46,5 +42,8 @@
<paragraph role="paragraph" id="par_id3155845" xml-lang="en-US">What date is one month prior to 2001-03-31?</paragraph>
<paragraph role="paragraph" id="par_id3155999" xml-lang="en-US">
<item type="input">=EDATE("2001-03-31";-1)</item> returns the serial number 36950. Formatted as a date, this is 2001-02-28.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_eomonth.xhp b/source/text/scalc/01/func_eomonth.xhp
index 19f98584b..186c4e948 100644
--- a/source/text/scalc/01/func_eomonth.xhp
+++ b/source/text/scalc/01/func_eomonth.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_eomonthxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">EOMONTH</title>
@@ -31,9 +26,10 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3150991"><bookmark_value>EOMONTH function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_EOMONTH" id="bm_id3158439" localize="false"/><paragraph role="heading" id="hd_id3150991" xml-lang="en-US" level="2"><variable id="eomonth"><link href="text/scalc/01/func_eomonth.xhp">EOMONTH</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_EOMONTH" id="bm_id3158439" localize="false"/><h2 id="hd_id3150991"><variable id="eomonth"><link href="text/scalc/01/func_eomonth.xhp">EOMONTH</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3152766" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_EOMONTH">Returns the date of the last day of a month which falls months away from the start date.</ahelp></paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3150351" xml-lang="en-US">EOMONTH(StartDate; Months)</paragraph>
<paragraph role="paragraph" id="par_id3146787" xml-lang="en-US">
@@ -45,6 +41,8 @@
<paragraph role="paragraph" id="par_id3156143" xml-lang="en-US"><item type="input">=EOMONTH(DATE(2001;9;14);6)</item> returns the serial number 37346. Formatted as a date, this is 2002-03-31.</paragraph>
<paragraph role="paragraph" id="par_id3156144" xml-lang="en-US"><item type="input">=EOMONTH("2001-09-14";6)</item> works as well. If the date is given as string, it has to be in ISO format.</paragraph>
-
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_hour.xhp b/source/text/scalc/01/func_hour.xhp
index d4409245e..9936d2914 100644
--- a/source/text/scalc/01/func_hour.xhp
+++ b/source/text/scalc/01/func_hour.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_hourxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">HOUR </title>
@@ -31,9 +26,10 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3154725"><bookmark_value>HOUR function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STUNDE" id="bm_id3152469" localize="false"/><paragraph role="heading" id="hd_id3154725" xml-lang="en-US" level="2"><variable id="hour"><link href="text/scalc/01/func_hour.xhp">HOUR</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STUNDE" id="bm_id3152469" localize="false"/><h2 id="hd_id3154725"><variable id="hour"><link href="text/scalc/01/func_hour.xhp">HOUR</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3149747" xml-lang="en-US"><ahelp hid="HID_FUNC_STUNDE">Returns the hour for a given time value.</ahelp> The hour is returned as an integer between 0 and 23.</paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3150637" xml-lang="en-US">HOUR(Number)</paragraph>
<paragraph role="paragraph" id="par_id3147547" xml-lang="en-US">
@@ -43,7 +39,8 @@
<item type="input">=HOUR(NOW())</item> returns the current hour</paragraph>
<paragraph role="paragraph" id="par_id3145152" xml-lang="en-US">
<item type="input">=HOUR(C4)</item> returns 17 if the contents of C4 = <item type="input">17:20:00</item>.</paragraph>
-<embed href="text/shared/00/00000001.xhp#siehe"/>
-<paragraph role="paragraph" id="par_id3154188" xml-lang="en-US"><link href="text/scalc/01/04060102.xhp" name="YEAR">YEAR</link>, <link href="text/scalc/01/04060102.xhp" name="NOW">NOW</link>, <link href="text/scalc/01/04060102.xhp" name="MINUTE">MINUTE</link>, <link href="text/scalc/01/04060102.xhp" name="MONTH">MONTH</link>, <link href="text/scalc/01/04060102.xhp" name="DAY">DAY</link>, <link href="text/scalc/01/04060102.xhp" name="WEEKDAY">WEEKDAY</link>.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_isoweeknum.xhp b/source/text/scalc/01/func_isoweeknum.xhp
index 9556aecd4..96f58c866 100644
--- a/source/text/scalc/01/func_isoweeknum.xhp
+++ b/source/text/scalc/01/func_isoweeknum.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_isoweeknumxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">ISOWEEKNUM</title>
@@ -31,11 +26,12 @@
<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"><variable id="isoweeknum"><link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISOWEEKNUM" id="bm_id3158403" localize="false"/><h2 id="hd_id3159161"><variable id="isoweeknum"><link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3149770" xml-lang="en-US"><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">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>
+<note id="par_idN105E4">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.</note>
<embed href="text/scalc/00/avail_release.xhp#5.1"/>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3147236" xml-lang="en-US">ISOWEEKNUM(Number)</paragraph>
<paragraph role="paragraph" id="par_id3147511" xml-lang="en-US">
@@ -45,5 +41,8 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3149792" xml-lang="en-US"><item type="input">=ISOWEEKNUM(DATE(1995;1;1))</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">=ISOWEEKNUM(DATE(1999;1;1))</item> returns 53. Week 1 starts on Monday, 1999-01-04.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_minute.xhp b/source/text/scalc/01/func_minute.xhp
index 91c4cb1c0..1bea6607f 100644
--- a/source/text/scalc/01/func_minute.xhp
+++ b/source/text/scalc/01/func_minute.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_minutexml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">MINUTE</title>
@@ -31,9 +26,10 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3149803"><bookmark_value>MINUTE function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINUTE" id="bm_id3148616" localize="false"/><paragraph role="heading" id="hd_id3149803" xml-lang="en-US" level="2"><variable id="minute"><link href="text/scalc/01/func_minute.xhp">MINUTE</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINUTE" id="bm_id3148616" localize="false"/><h2 id="hd_id3149803"><variable id="minute"><link href="text/scalc/01/func_minute.xhp">MINUTE</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3148988" xml-lang="en-US"><ahelp hid="HID_FUNC_MINUTE">Calculates the minute for an internal time value.</ahelp> The minute is returned as a number between 0 and 59.</paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3148660" xml-lang="en-US">MINUTE(Number)</paragraph>
<paragraph role="paragraph" id="par_id3154611" xml-lang="en-US">
@@ -45,5 +41,8 @@
<item type="input">=MINUTE(8.9999)</item> returns 59</paragraph>
<paragraph role="paragraph" id="par_id3144755" xml-lang="en-US">
<item type="input">=MINUTE(NOW())</item> returns the current minute value.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_month.xhp b/source/text/scalc/01/func_month.xhp
index 038db6f65..9ae8ce5f5 100644
--- a/source/text/scalc/01/func_month.xhp
+++ b/source/text/scalc/01/func_month.xhp
@@ -26,9 +26,10 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3149936"><bookmark_value>MONTH function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MONAT" id="bm_id3150628" localize="false"/><paragraph role="heading" id="hd_id3149936" xml-lang="en-US" level="2"><variable id="month"><link href="text/scalc/01/func_month.xhp">MONTH</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MONAT" id="bm_id3150628" localize="false"/><h2 id="hd_id3149936"><variable id="month"><link href="text/scalc/01/func_month.xhp">MONTH</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3153538" xml-lang="en-US"><ahelp hid="HID_FUNC_MONAT">Returns the month for the given date value.</ahelp> The month is returned as an integer between 1 and 12.</paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3145602" xml-lang="en-US">MONTH(Number)</paragraph>
<paragraph role="paragraph" id="par_id3149485" xml-lang="en-US">
@@ -38,5 +39,8 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3149244" xml-lang="en-US"><item type="input">=MONTH(NOW())</item> returns the current month.</paragraph>
<paragraph role="paragraph" id="par_id3154790" xml-lang="en-US"><item type="input">=MONTH(C4)</item> returns 7 if you enter 2000-07-07 to cell C4 (that date value might get formatted differently after you press Enter).</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_networkdays.intl.xhp b/source/text/scalc/01/func_networkdays.intl.xhp
index 5df0a4556..643387924 100644
--- a/source/text/scalc/01/func_networkdays.intl.xhp
+++ b/source/text/scalc/01/func_networkdays.intl.xhp
@@ -51,10 +51,7 @@
<paragraph id="par_id231020162249556946" role="paragraph" xml-lang="en-US">The function can be used without the two optional parameters – weekday and holidays – by leaving them out:</paragraph>
<paragraph id="par_id23102016224955931" role="paragraph" xml-lang="en-US"><item type="input">=NETWORKDAYS.INTL(C3;D3)</item> gives 22 working days.</paragraph>
<section id="relatedtopics">
- <embed href="text/scalc/01/func_networkdays.xhp#networkdays"/>
- <embed href="text/scalc/01/func_workday.intl.xhp#workdaysintl"/>
- <embed href="text/scalc/01/func_workday.xhp#workday"/>
-<paragraph id="par_id23102016225717242" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date functions</link></paragraph>
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_networkdays.xhp b/source/text/scalc/01/func_networkdays.xhp
index f22da61b0..19527b6f5 100644
--- a/source/text/scalc/01/func_networkdays.xhp
+++ b/source/text/scalc/01/func_networkdays.xhp
@@ -37,6 +37,7 @@
<h2 id="hd_id3151254"><variable id="networkdays"><link href="text/scalc/01/func_networkdays.xhp">NETWORKDAYS</link></variable></h2>
<paragraph id="par_id3153788" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_NETWORKDAYS">Returns the number of workdays between a <emph>start date</emph> and an <emph>end date</emph>. Holidays can be deducted.</ahelp></paragraph>
<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3145775" role="code" xml-lang="en-US">NETWORKDAYS(StartDate; EndDate; Holidays; Workdays)</paragraph>
<paragraph id="par_id3153885" role="paragraph" xml-lang="en-US"><emph>StartDate</emph> is the date from when the calculation is carried out. If the start date is a workday, the day is included in the calculation.</paragraph>
@@ -51,11 +52,7 @@
<paragraph id="par_id160920161751233621" role="paragraph" xml-lang="en-US">How many workdays fall between September 12nd and 25th in 2016 if only Mondays, Tuesdays and Wednesdays are considered as workdays?</paragraph>
<paragraph id="par_id160920161751235483" role="paragraph" xml-lang="en-US"><item type="input">=NETWORKDAYS(DATE(2016;9;12); DATE(2016;9;25); ; {1;0;0;0;1;1;1})</item> returns 6 workdays.</paragraph>
<section id="relatedtopics">
- <embed href="text/scalc/01/func_networkdays.intl.xhp#networkdaysintl"/>
- <embed href="text/scalc/01/func_workday.intl.xhp#workdaysintl"/>
- <embed href="text/scalc/01/func_workday.xhp#workday"/>
-<paragraph id="par_id23102016225717242" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date functions</link></paragraph>
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
-
</helpdocument>
diff --git a/source/text/scalc/01/func_now.xhp b/source/text/scalc/01/func_now.xhp
index 1d241fb8c..fbb84d2ed 100644
--- a/source/text/scalc/01/func_now.xhp
+++ b/source/text/scalc/01/func_now.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_nowxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">NOW</title>
@@ -31,14 +26,18 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3150521"><bookmark_value>NOW function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JETZT" id="bm_id3150532" localize="false"/><paragraph role="heading" id="hd_id3150521" xml-lang="en-US" level="2"><variable id="now"><link href="text/scalc/01/func_now.xhp">NOW</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JETZT" id="bm_id3150532" localize="false"/><h2 id="hd_id3150521"><variable id="now"><link href="text/scalc/01/func_now.xhp">NOW</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3148829" xml-lang="en-US"><ahelp hid="HID_FUNC_JETZT">Returns the computer system date and time.</ahelp> The value is updated when you recalculate the document or each time a cell value is modified.</paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3154897" xml-lang="en-US">NOW()</paragraph>
<paragraph role="paragraph" id="par_id4598529" xml-lang="en-US">NOW is a function without arguments.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3150774" xml-lang="en-US">
<item type="input">=NOW()-A1</item> returns the difference between the date in A1 and now. Format the result as a number.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_second.xhp b/source/text/scalc/01/func_second.xhp
index a51a4801b..0baee1eed 100644
--- a/source/text/scalc/01/func_second.xhp
+++ b/source/text/scalc/01/func_second.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_secondxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">SECOND </title>
@@ -31,9 +26,10 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3159390"><bookmark_value>SECOND function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SEKUNDE" id="bm_id3155499" localize="false"/><paragraph role="heading" id="hd_id3159390" xml-lang="en-US" level="2"><variable id="second"><link href="text/scalc/01/func_second.xhp">SECOND</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SEKUNDE" id="bm_id3155499" localize="false"/><h2 id="hd_id3159390"><variable id="second"><link href="text/scalc/01/func_second.xhp">SECOND</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3148974" xml-lang="en-US"><ahelp hid="HID_FUNC_SEKUNDE">Returns the second for the given time value.</ahelp> The second is given as an integer between 0 and 59.</paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3148407" xml-lang="en-US">SECOND(Number)</paragraph>
<paragraph role="paragraph" id="par_id3155904" xml-lang="en-US">
@@ -43,5 +39,8 @@
<item type="input">=SECOND(NOW())</item> returns the current second</paragraph>
<paragraph role="paragraph" id="par_id3150831" xml-lang="en-US">
<item type="input">=SECOND(C4)</item> returns 17 if contents of C4 = <item type="input">12:20:17</item>.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_time.xhp b/source/text/scalc/01/func_time.xhp
index de55b8a66..1aac1737c 100644
--- a/source/text/scalc/01/func_time.xhp
+++ b/source/text/scalc/01/func_time.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_timexml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">TIME </title>
@@ -31,9 +26,10 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3154073"><bookmark_value>TIME function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEIT" id="bm_id3150289" localize="false"/><paragraph role="heading" id="hd_id3154073" xml-lang="en-US" level="2"><variable id="time"><link href="text/scalc/01/func_time.xhp">TIME</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEIT" id="bm_id3150289" localize="false"/><h2 id="hd_id3154073"><variable id="time"><link href="text/scalc/01/func_time.xhp">TIME</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3145762" xml-lang="en-US"><ahelp hid="HID_FUNC_ZEIT">TIME returns the current time value from values for hours, minutes and seconds.</ahelp> This function can be used to convert a time based on these three elements to a decimal time value.</paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3154584" xml-lang="en-US">TIME(Hour; Minute; Second)</paragraph>
<paragraph role="paragraph" id="par_id3152904" xml-lang="en-US">Use an integer to set the <emph>Hour</emph>.</paragraph>
@@ -44,5 +40,8 @@
<item type="input">=TIME(0;0;0)</item> returns 00:00:00</paragraph>
<paragraph role="paragraph" id="par_id3156090" xml-lang="en-US">
<item type="input">=TIME(4;20;4)</item> returns 04:20:04</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_timevalue.xhp b/source/text/scalc/01/func_timevalue.xhp
index eb03aada5..7e6f442d5 100644
--- a/source/text/scalc/01/func_timevalue.xhp
+++ b/source/text/scalc/01/func_timevalue.xhp
@@ -28,8 +28,9 @@
<bookmark_value>TIMEVALUE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEITWERT" id="bm_id3146767" localize="false"/>
-<paragraph id="hd_id3146755" role="heading" xml-lang="en-US" level="2"><variable id="timevalue"><link href="text/scalc/01/func_timevalue.xhp">TIMEVALUE</link></variable></paragraph>
-<paragraph id="par_id3148502" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZEITWERT">TIMEVALUE returns the internal time number from a text enclosed by quotes and which may show a possible time entry format.</ahelp></paragraph><embed href="text/scalc/01/ODFF.xhp#odff"/>
+<h2 id="hd_id3146755"><variable id="timevalue"><link href="text/scalc/01/func_timevalue.xhp">TIMEVALUE</link></variable></h2>
+<paragraph id="par_id3148502" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZEITWERT">TIMEVALUE returns the internal time number from a text enclosed by quotes and which may show a possible time entry format.</ahelp></paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<paragraph id="par_id3150794" role="paragraph" xml-lang="en-US">The internal number indicated as a decimal is the result of the date system used under $[officename] to calculate date entries.</paragraph>
<paragraph id="par_id011920090347118" role="paragraph" xml-lang="en-US">If the text string also includes a year, month, or day, TIMEVALUE only returns the fractional part of the conversion.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -38,5 +39,8 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3146829" role="paragraph" xml-lang="en-US"><item type="input">=TIMEVALUE("4PM")</item> returns 0.67. When formatting in time format HH:MM:SS, you then get 16:00:00.</paragraph>
<paragraph id="par_id3153632" role="paragraph" xml-lang="en-US"><item type="input">=TIMEVALUE("24:00")</item> returns 0. If you use the HH:MM:SS time format, the value is 00:00:00.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_today.xhp b/source/text/scalc/01/func_today.xhp
index 35b6bfdd2..ac5fee6e8 100644
--- a/source/text/scalc/01/func_today.xhp
+++ b/source/text/scalc/01/func_today.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_todayxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">TODAY</title>
@@ -31,14 +26,18 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3145659"><bookmark_value>TODAY function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HEUTE" id="bm_id3147267" localize="false"/><paragraph role="heading" id="hd_id3145659" xml-lang="en-US" level="2"><variable id="today"><link href="text/scalc/01/func_today.xhp">TODAY</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HEUTE" id="bm_id3147267" localize="false"/><h2 id="hd_id3145659"><variable id="today"><link href="text/scalc/01/func_today.xhp">TODAY</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3153759" xml-lang="en-US"><ahelp hid="HID_FUNC_HEUTE">Returns the current computer system date.</ahelp> The value is updated when you reopen the document or modify the values of the document.</paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3153154" xml-lang="en-US">TODAY()</paragraph>
<paragraph role="paragraph" id="par_id3154741" xml-lang="en-US"> TODAY is a function without arguments.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3156106" xml-lang="en-US">
<item type="input">TODAY()</item> returns the current computer system date.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_weekday.xhp b/source/text/scalc/01/func_weekday.xhp
index 2f23bdb6d..2cc26363f 100644
--- a/source/text/scalc/01/func_weekday.xhp
+++ b/source/text/scalc/01/func_weekday.xhp
@@ -33,9 +33,9 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WOCHENTAG" id="bm_id3152359" localize="false"/>
-<paragraph id="hd_id3154925" role="heading" level="2" xml-lang="en-US"><variable id="weekday"><link href="text/scalc/01/func_weekday.xhp">WEEKDAY</link> </variable></paragraph>
+<h2 id="hd_id3154925"><variable id="weekday"><link href="text/scalc/01/func_weekday.xhp">WEEKDAY</link> </variable></h2>
<paragraph id="par_id3154228" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_WOCHENTAG">Returns the day of the week for the given date value.</ahelp> The day is returned as an integer between 1 (Sunday) and 7 (Saturday) if no type or type=1 is specified. For other types, see the table below.</paragraph>
-
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3149033" role="code" xml-lang="en-US">WEEKDAY(Number; Type)</paragraph>
<paragraph id="par_id3149046" role="paragraph" xml-lang="en-US"> <emph>Number</emph>, as a date value, is a decimal for which the weekday is to be returned.</paragraph>
@@ -132,8 +132,8 @@
</tablerow>
</table>
-<paragraph id="par_id3156188" role="note" xml-lang="en-US">These values apply only to the standard date format that you select under <switchinline select="sys"><caseinline select="MAC"><item type="menuitem">%PRODUCTNAME - Preferences</item>
-</caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><item type="menuitem">- %PRODUCTNAME Calc - Calculate</item>.</paragraph>
+<note id="par_id3156188">These values apply only to the standard date format that you select under <switchinline select="sys"><caseinline select="MAC"><item type="menuitem">%PRODUCTNAME - Preferences</item>
+</caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><item type="menuitem">- %PRODUCTNAME Calc - Calculate</item>.</note>
<embed href="text/scalc/01/04060102.xhp#datenumberinfo"/>
<embed href="text/scalc/01/04060102.xhp#datenumberwarn"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
@@ -142,7 +142,10 @@
<paragraph id="par_id3153525" role="paragraph" xml-lang="en-US"><item type="input">=WEEKDAY("1996-07-24";1)</item> returns 4 (the Type parameter is 1, therefore Sunday is day number 1. July 24, 1996 was a Wednesday and therefore day number 4).</paragraph>
<paragraph id="par_id050220170616006699" role="paragraph" xml-lang="en-US"><item type="input">=WEEKDAY("2017-05-02";14)</item> returns 6 (the Type parameter is 14, therefore Thursday is day number 1. May 2, 2017 was a Tuesday and therefore day number 6)</paragraph>
<paragraph id="par_id3150575" role="paragraph" xml-lang="en-US"><item type="input">=WEEKDAY(NOW())</item> returns the number of the current day.</paragraph>
-<paragraph id="par_id3150588" role="tip" xml-lang="en-US">To obtain a function indicating whether a day in A1 is a business day, use the IF and WEEKDAY functions as follows: <br/><item type="input">IF(WEEKDAY(A1;2)<6;"Business day";"Weekend")</item></paragraph>
+<tip id="par_id3150588">To obtain a function indicating whether a day in A1 is a business day, use the IF and WEEKDAY functions as follows: <br/><item type="input">IF(WEEKDAY(A1;2)<6;"Business day";"Weekend")</item></tip>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_weeknum.xhp b/source/text/scalc/01/func_weeknum.xhp
index 31695d995..a23d5cdf5 100644
--- a/source/text/scalc/01/func_weeknum.xhp
+++ b/source/text/scalc/01/func_weeknum.xhp
@@ -26,8 +26,8 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3159161"><bookmark_value>WEEKNUM function</bookmark_value>
</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"><variable id="weeknum"><link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KALENDERWOCHE" id="bm_id3158403" localize="false"/><h2 id="hd_id3159161"><variable id="weeknum"><link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3149770" xml-lang="en-US"><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">Supported are two week numbering systems:</paragraph>
<table id="tab_id481535122363435">
@@ -49,13 +49,14 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id741535122455285" role="tablecontent" xml-lang="en-US" >System 2</paragraph>
+ <paragraph id="par_id741535122455285" role="tablecontent" xml-lang="en-US">System 2</paragraph>
</tablecell>
<tablecell>
<paragraph role="tablecontent" id="par_id3147222" xml-lang="en-US">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>
</tablecell>
</tablerow>
</table>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3147236" xml-lang="en-US">WEEKNUM(Number [; Mode])</paragraph>
<paragraph role="paragraph" id="par_id3147511" xml-lang="en-US">
@@ -65,7 +66,7 @@
<table id="tab_id491535122633826">
<tablerow>
<tablecell>
- <paragraph id="par_id961535122993923" role="tablehead" xml-lang="en-US" >System</paragraph>
+ <paragraph id="par_id961535122993923" role="tablehead" xml-lang="en-US">System</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id151535122633826" role="tablehead" xml-lang="en-US">Mode</paragraph>
@@ -76,7 +77,7 @@
</tablerow>
<tablerow>
<tablecell rowspan="9">
- <paragraph id="par_id531535124180000" role="tablecontents" xml-lang="en-US" >System 1</paragraph>
+ <paragraph id="par_id531535124180000" role="tablecontents" xml-lang="en-US">System 1</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id931535122633827" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
@@ -90,7 +91,7 @@
<paragraph id="par_id441535122735565" role="tablecontents" xml-lang="en-US" localize="false">2</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id591535122756686" role="tablecontents" xml-lang="en-US" >Monday</paragraph>
+ <paragraph id="par_id591535122756686" role="tablecontents" xml-lang="en-US">Monday</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -98,7 +99,7 @@
<paragraph id="par_id541535122798459" role="tablecontents" xml-lang="en-US" localize="false">11</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id881535122835126" role="tablecontents" xml-lang="en-US" >Monday</paragraph>
+ <paragraph id="par_id881535122835126" role="tablecontents" xml-lang="en-US">Monday</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -106,7 +107,7 @@
<paragraph id="par_id941535122866815" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id241535122903569" role="tablecontents" xml-lang="en-US" >Tuesday</paragraph>
+ <paragraph id="par_id241535122903569" role="tablecontents" xml-lang="en-US">Tuesday</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -114,7 +115,7 @@
<paragraph id="par_id271535124253476" role="tablecontents" xml-lang="en-US" localize="false">13</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id31535124277973" role="tablecontents" xml-lang="en-US" >Wednesday</paragraph>
+ <paragraph id="par_id31535124277973" role="tablecontents" xml-lang="en-US">Wednesday</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -122,7 +123,7 @@
<paragraph id="par_id281535124290548" role="tablecontents" xml-lang="en-US" localize="false">14</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id21535124310462" role="tablecontents" xml-lang="en-US" >Thursday</paragraph>
+ <paragraph id="par_id21535124310462" role="tablecontents" xml-lang="en-US">Thursday</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -130,7 +131,7 @@
<paragraph id="par_id721535124338290" role="tablecontents" xml-lang="en-US" localize="false">15</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id921535124365435" role="tablecontents" xml-lang="en-US" >Friday</paragraph>
+ <paragraph id="par_id921535124365435" role="tablecontents" xml-lang="en-US">Friday</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -138,26 +139,26 @@
<paragraph id="par_id781535124380237" role="tablecontents" xml-lang="en-US" localize="false">16</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id211535124416253" role="tablecontents" xml-lang="en-US" >Saturday</paragraph>
+ <paragraph id="par_id211535124416253" role="tablecontents" xml-lang="en-US">Saturday</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id601535124440320" role="tablecontents" xml-lang="en-US" localize="false" >17</paragraph>
+ <paragraph id="par_id601535124440320" role="tablecontents" xml-lang="en-US" localize="false">17</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id461535124473824" role="tablecontents" xml-lang="en-US" >Sunday</paragraph>
+ <paragraph id="par_id461535124473824" role="tablecontents" xml-lang="en-US">Sunday</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell rowspan="2">
- <paragraph id="par_id471535124489997" role="tablecontents" xml-lang="en-US" >System 2</paragraph>
+ <paragraph id="par_id471535124489997" role="tablecontents" xml-lang="en-US">System 2</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id431535124539573" role="tablecontents" xml-lang="en-US" localize="false">21</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id391535124564520" role="tablecontents" xml-lang="en-US" >Monday (ISO 8601)</paragraph>
+ <paragraph id="par_id391535124564520" role="tablecontents" xml-lang="en-US">Monday (ISO 8601)</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -165,7 +166,7 @@
<paragraph id="par_id971535124578111" role="tablecontents" xml-lang="en-US" localize="false">150</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id661535124640643" role="tablecontents" xml-lang="en-US" >(ISO 8601, for interoperability with Gnumeric)</paragraph>
+ <paragraph id="par_id661535124640643" role="tablecontents" xml-lang="en-US">(ISO 8601, for interoperability with Gnumeric)</paragraph>
</tablecell>
</tablerow>
</table>
@@ -176,5 +177,8 @@
<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_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">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_weeknum_ooo.xhp b/source/text/scalc/01/func_weeknum_ooo.xhp
index 8304d3a97..a4de84092 100644
--- a/source/text/scalc/01/func_weeknum_ooo.xhp
+++ b/source/text/scalc/01/func_weeknum_ooo.xhp
@@ -26,10 +26,10 @@
<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"><variable id="weeknum_ooo"><link href="text/scalc/01/func_weeknum_ooo.xhp">WEEKNUM_OOO</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEEKNUM_OOO" id="bm_id3158403" localize="false"/><h2 id="hd_id3159161"><variable id="weeknum_ooo"><link href="text/scalc/01/func_weeknum_ooo.xhp">WEEKNUM_OOO</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3149770" xml-lang="en-US"><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">This function exists for interoperability with %PRODUCTNAME 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>
+<note id="par_idN105E4">This function exists for interoperability with %PRODUCTNAME 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.</note>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3147236" xml-lang="en-US">WEEKNUM_OOO(Number; Mode)</paragraph>
<paragraph role="paragraph" id="par_id3147511" xml-lang="en-US">
@@ -44,5 +44,8 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3150704" xml-lang="en-US"><item type="input">=WEEKNUM_OOO(DATE(1995;1;1);1)</item> returns 1</paragraph>
<paragraph role="paragraph" id="par_id3149792" xml-lang="en-US"><item type="input">=WEEKNUM_OOO(DATE(1995;1;1);2)</item> returns 52. Week 1 starts on Monday, 1995-01-02.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_weeknumadd.xhp b/source/text/scalc/01/func_weeknumadd.xhp
index 53f234773..57f838d9a 100644
--- a/source/text/scalc/01/func_weeknumadd.xhp
+++ b/source/text/scalc/01/func_weeknumadd.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_weeknumaddxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">WEEKNUM_EXCEL2003 </title>
@@ -31,10 +26,10 @@
<body>
<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"><variable id="weeknumadd"><link href="text/scalc/01/func_weeknumadd.xhp">WEEKNUM_EXCEL2003</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_WEEKNUM" id="bm_id3166454" localize="false"/><h2 id="hd_id3166443"><variable id="weeknumadd"><link href="text/scalc/01/func_weeknumadd.xhp">WEEKNUM_EXCEL2003</link>
+</variable></h2>
<paragraph role="paragraph" id="par_id3152945" xml-lang="en-US"><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">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>
+<tip id="par_idN105DD">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.</tip>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3153685" xml-lang="en-US">WEEKNUM_EXCEL2003(Date; ReturnType)</paragraph>
<paragraph role="paragraph" id="par_id3159277" xml-lang="en-US">
@@ -45,5 +40,8 @@
<paragraph role="paragraph" id="par_id3149973" xml-lang="en-US">In which week number does 2001-12-24 fall?</paragraph>
<paragraph role="paragraph" id="par_id3149914" xml-lang="en-US">
<item type="input">=WEEKNUM_EXCEL2003(DATE(2001;12;24);1)</item> returns 52.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_workday.intl.xhp b/source/text/scalc/01/func_workday.intl.xhp
index 4f4a31ae9..c986c5be3 100644
--- a/source/text/scalc/01/func_workday.intl.xhp
+++ b/source/text/scalc/01/func_workday.intl.xhp
@@ -57,10 +57,7 @@
<paragraph id="par_id241020160012181870" role="paragraph" xml-lang="en-US">The function can be used without the two optional parameters – Weekday and Holidays – by leaving them out:</paragraph>
<paragraph id="par_id241020160012182048" role="paragraph" xml-lang="en-US"><item type="input">=WORKDAY.INTL(C3;D3)</item> gives the result: January 10, 2017.</paragraph>
<section id="relatedtopics">
- <embed href="text/scalc/01/func_networkdays.xhp#networkdays"/>
- <embed href="text/scalc/01/func_networkdays.intl.xhp#networkdaysintl"/>
- <embed href="text/scalc/01/func_workday.xhp#workday"/>
-<paragraph id="par_id23102016225717242" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date functions</link></paragraph>
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_workday.xhp b/source/text/scalc/01/func_workday.xhp
index 21120d6e0..bd6f5c003 100644
--- a/source/text/scalc/01/func_workday.xhp
+++ b/source/text/scalc/01/func_workday.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_workdayxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">WORKDAY</title>
@@ -34,6 +29,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_WORKDAY" id="bm_id3150028" localize="false"/>
<h2 id="hd_id3149012"><variable id="workday"><link href="text/scalc/01/func_workday.xhp">WORKDAY</link></variable></h2>
<paragraph role="paragraph" id="par_id3149893" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_WORKDAY"> The result is a date number that can be formatted as a date. You then see the date of a day that is a certain number of <emph>workdays</emph> away from the <emph>start date</emph>.</ahelp></paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3154844" xml-lang="en-US">WORKDAY(StartDate; Days; Holidays)</paragraph>
<paragraph role="paragraph" id="par_id3147469" xml-lang="en-US">
@@ -53,5 +49,8 @@
<embed href="text/scalc/01/func_workday.intl.xhp#workdaysintl"/>
<paragraph id="par_id23102016225717242" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date functions</link></paragraph>
</section>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_year.xhp b/source/text/scalc/01/func_year.xhp
index 0adf3b23c..c2fe1b635 100644
--- a/source/text/scalc/01/func_year.xhp
+++ b/source/text/scalc/01/func_year.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_yearxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">YEAR</title>
@@ -31,9 +26,10 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3153982"><bookmark_value>YEAR function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JAHR" id="bm_id3159179" localize="false"/><paragraph role="heading" id="hd_id3153982" xml-lang="en-US" level="2"><variable id="year"><link href="text/scalc/01/func_year.xhp">YEAR</link>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3147496" xml-lang="en-US"><ahelp hid="HID_FUNC_JAHR">Returns the year as a number according to the internal calculation rules.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JAHR" id="bm_id3159179" localize="false"/><h2 id="hd_id3153982"><variable id="year"><link href="text/scalc/01/func_year.xhp">YEAR</link>
+</variable></h2>
+<paragraph role="paragraph" id="par_id3147496" xml-lang="en-US"><ahelp hid="HID_FUNC_JAHR">Returns the year as a number according to the <link href="text/scalc/01/04060102.xhp#datebase" name="date calculation rules">internal calculation rules</link>.</ahelp></paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3154304" xml-lang="en-US">YEAR(Number)</paragraph>
<paragraph role="paragraph" id="par_id3156013" xml-lang="en-US">
@@ -45,5 +41,10 @@
<item type="input">=YEAR(2)</item> returns 1900</paragraph>
<paragraph role="paragraph" id="par_id3150115" xml-lang="en-US">
<item type="input">=YEAR(33333.33)</item> returns 1991</paragraph>
+<paragraph role="paragraph" id="par_id141577548861101"><input>=YEAR(DATEVALUE('2010-09-28'))</input> returns 2010.</paragraph>
+
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_yearfrac.xhp b/source/text/scalc/01/func_yearfrac.xhp
index 20d5747c8..059a0e202 100644
--- a/source/text/scalc/01/func_yearfrac.xhp
+++ b/source/text/scalc/01/func_yearfrac.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,9 +16,7 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_yearfracxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">YEARFRAC</title>
@@ -31,9 +26,10 @@
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3148735"><bookmark_value>YEARFRAC function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_YEARFRAC" id="bm_id3149251" localize="false"/><paragraph role="heading" id="hd_id3148735" xml-lang="en-US" level="2"><variable id="yearfrac"><link href="text/scalc/01/func_yearfrac.xhp">YEARFRAC</link>
-</variable></paragraph>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_YEARFRAC" id="bm_id3149251" localize="false"/>
+<h2 id="hd_id3148735"><variable id="yearfrac"><link href="text/scalc/01/func_yearfrac.xhp">YEARFRAC</link></variable></h2>
<paragraph role="paragraph" id="par_id3150899" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_YEARFRAC">The result is the number of the years (including fractional part) between <emph>StartDate</emph> and <emph>EndDate</emph>.</ahelp></paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3155823" xml-lang="en-US">YEARFRAC(StartDate; EndDate; Basis)</paragraph>
<paragraph role="paragraph" id="par_id3145144" xml-lang="en-US">
@@ -46,47 +42,47 @@
<tablecell>
<paragraph role="tablehead" id="par_id3146847" xml-lang="en-US">Basis</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablehead" id="par_id3155956" xml-lang="en-US">Calculation</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3154502" xml-lang="en-US" localize="false">0 or missing</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3149877" xml-lang="en-US">US method (NASD), 12 months of 30 days each</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3148766" xml-lang="en-US" localize="false">1</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3154326" xml-lang="en-US">Exact number of days in months, exact number of days in year</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3145245" xml-lang="en-US" localize="false">2</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3155620" xml-lang="en-US">Exact number of days in month, year has 360 days</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3145297" xml-lang="en-US" localize="false">3</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3148394" xml-lang="en-US">Exact number of days in month, year has 365 days</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3151022" xml-lang="en-US" localize="false">4</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3150931" xml-lang="en-US">European method, 12 months of 30 days each</paragraph>
</tablecell>
</tablerow>
@@ -97,5 +93,8 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3149007" xml-lang="en-US">What fraction of the year 2008 lies between 2008-01-01 and 2008-07-01?</paragraph>
<paragraph role="paragraph" id="par_id3154632" xml-lang="en-US"><item type="input">=YEARFRAC("2008-01-01"; "2008-07-01";0)</item> returns 0.50.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
+</section>
</body>
</helpdocument>
More information about the Libreoffice-commits
mailing list