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.hal...@libreoffice.org>
AuthorDate: Sat Dec 28 13:52:39 2019 -0300
Commit: Olivier Hallot <olivier.hal...@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.hal...@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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
