AllLangHelp_scalc.mk | 3
help3xsl/get_bookmark.sh | 14 -
source/text/scalc/01/04060102.xhp | 264 ++++++++++------------
source/text/scalc/01/common_func_workdaysintl.xhp | 163 +++++++++++++
source/text/scalc/01/func_networkdays.intl.xhp | 65 +++++
source/text/scalc/01/func_networkdays.xhp | 6
source/text/scalc/01/func_workday.xhp | 6
source/text/scalc/01/func_workdays.intl.xhp | 66 +++++
8 files changed, 445 insertions(+), 142 deletions(-)
New commits:
commit b560ca36513ef209b23081dc5b971d30dd60e5f1
Author: Chandanathil P. Geevan <cpgee...@gmail.com>
Date: Mon Oct 24 01:05:12 2016 -0200
tdf#80439 Help pages for (NET)WORKDAYS.INTL
removed useless file
replaced commas with semicolons in function expression
Change-Id: I76ce8945d7f5d51f7b356dc8063db1b4623e905b
Reviewed-on: https://gerrit.libreoffice.org/30217
Reviewed-by: Olivier Hallot <olivier.hal...@edx.srv.br>
Tested-by: Olivier Hallot <olivier.hal...@edx.srv.br>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 4574dfc..e9cb083 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -220,7 +220,10 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_isoweeknum \
helpcontent2/source/text/scalc/01/func_minute \
helpcontent2/source/text/scalc/01/func_month \
+ helpcontent2/source/text/scalc/01/common_func_workdaysintl \
helpcontent2/source/text/scalc/01/func_networkdays \
+ helpcontent2/source/text/scalc/01/func_networkdays.intl \
+ helpcontent2/source/text/scalc/01/func_workdays.intl \
helpcontent2/source/text/scalc/01/func_numbervalue \
helpcontent2/source/text/scalc/01/func_now \
helpcontent2/source/text/scalc/01/func_second \
diff --git a/help3xsl/get_bookmark.sh b/help3xsl/get_bookmark.sh
index 2ae124c..b8e7ee6 100755
--- a/help3xsl/get_bookmark.sh
+++ b/help3xsl/get_bookmark.sh
@@ -1,11 +1,11 @@
#/bin/bash
-<!--
- * This file is part of the LibreOffice project.
- *
- * This Source Code Form is subject to the terms of the Mozilla Public
- * License, v. 2.0. If a copy of the MPL was not distributed with this
- * file, You can obtain one at http://mozilla.org/MPL/2.0/.
--->
+#*--
+#* This file is part of the LibreOffice project.
+#*
+#* This Source Code Form is subject to the terms of the Mozilla Public
+#* License, v. 2.0. If a copy of the MPL was not distributed with this
+#* file, You can obtain one at http://mozilla.org/MPL/2.0/.
+#*
stub1='<html><head><link rel="stylesheet" type="text/css"
href="/default.css"/></head><body><ul class="indexlink">'
stub2='</ul></body></html>'
diff --git a/source/text/scalc/01/04060102.xhp
b/source/text/scalc/01/04060102.xhp
index 09f3bf7..47e8ce1 100644
--- a/source/text/scalc/01/04060102.xhp
+++ b/source/text/scalc/01/04060102.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
<!--
* This file is part of the LibreOffice project.
*
@@ -17,207 +16,202 @@
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
- -->
-
-
+-->
+
<meta>
-<topic id="textscalc0104060102xml" indexer="include">
-<title id="tit" xml-lang="en-US">Date & Time Functions</title>
-<filename>/text/scalc/01/04060102.xhp</filename>
-</topic>
+ <topic id="textscalc0104060102xml" indexer="include">
+ <title id="tit" xml-lang="en-US">Date & Time Functions</title>
+ <filename>/text/scalc/01/04060102.xhp</filename>
+ </topic>
</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 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>
-<paragraph role="heading" id="hd_id3154536" xml-lang="en-US" level="1"
l10n="U" oldref="1">Date & Time Functions</paragraph>
-<paragraph role="paragraph" id="par_id3153973" xml-lang="en-US" l10n="U"
oldref="2"><variable id="datumzeittext">These spreadsheet functions are used
for inserting and editing dates and times.
-</variable></paragraph>
+
+
+<paragraph id="hd_id3154536" role="heading" level="1" xml-lang="en-US">Date
& Time Functions</paragraph>
+<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">
<embed href="text/scalc/00/00000404.xhp#eikadaze"/>
</section>
+
<section id="ADD_note">
-<paragraph role="note" id="par_idN10600" xml-lang="en-US" l10n="NEW">The
functions whose names end with _ADD or _EXCEL2003 return the same results as
the corresponding Microsoft Excel 2003 functions without the suffix. Use the
functions without suffix to get results based on international
standards.</paragraph>
+<paragraph id="par_idN10600" role="note" xml-lang="en-US">The functions whose
names end with _ADD or _EXCEL2003 return the same results as the corresponding
Microsoft Excel 2003 functions without the suffix. Use the functions without
suffix to get results based on international standards.</paragraph>
</section>
-<paragraph role="paragraph" id="par_id3150437" xml-lang="en-US" l10n="U"
oldref="170">$[officename] internally handles a date/time value as a numerical
value. If you assign the numbering format "Number" to a date or time value, it
is converted to a number. For example, 01/01/2000 12:00 PM, converts to
36526.5. The value preceding the decimal point corresponds to the date; the
value following the decimal point corresponds to the time. If you do not want
to see this type of numerical date or time representation, change the number
format (date or time) accordingly. To do this, select the cell containing the
date or time value, call its context menu and select <emph>Format Cells</emph>.
The <emph>Numbers</emph> tab page contains the functions for defining the
number format.</paragraph>
-<paragraph role="heading" id="hd_id2408825" xml-lang="en-US" level="2"
l10n="NEW">Date base for day zero</paragraph>
-<paragraph role="paragraph" id="par_id9988402" xml-lang="en-US"
l10n="NEW">Dates are calculated as offsets from a starting day zero. You can
set the day zero to be one of the following:</paragraph>
+<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>
+
+<paragraph id="hd_id2408825" role="heading" level="2" xml-lang="en-US">Date
base for day zero</paragraph>
+<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>
+
<table id="tbl_id1661427">
-<tablerow>
-<tablecell>
-<paragraph role="tablehead" id="par_id6401257" xml-lang="en-US"
l10n="NEW">Date base</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablehead" id="par_id5841242" xml-lang="en-US"
l10n="NEW">Use</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id6794030" xml-lang="en-US"
l10n="CHG">'12/30/1899'</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id7096774" xml-lang="en-US"
l10n="NEW">(default)</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id5699942" xml-lang="en-US"
l10n="CHG">'01/01/1900'</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id6420484" xml-lang="en-US"
l10n="NEW">(used in former StarCalc 1.0)</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id6986602" xml-lang="en-US"
l10n="CHG">'01/01/1904'</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id616779" xml-lang="en-US"
l10n="NEW">(used in Apple software)</paragraph>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id6401257" role="tablehead" xml-lang="en-US">Date
base</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id5841242" role="tablehead"
xml-lang="en-US">Use</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id6794030" role="tablecontent"
xml-lang="en-US">'12/30/1899'</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id7096774" role="tablecontent"
xml-lang="en-US">(default)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id5699942" role="tablecontent"
xml-lang="en-US">'01/01/1900'</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id6420484" role="tablecontent" xml-lang="en-US">(used
in former StarCalc 1.0)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id6986602" role="tablecontent"
xml-lang="en-US">'01/01/1904'</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id616779" role="tablecontent" xml-lang="en-US">(used
in Apple software)</paragraph>
+ </tablecell>
+ </tablerow>
</table>
-<paragraph role="paragraph" id="par_id791039" xml-lang="en-US"
l10n="NEW">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>
-<paragraph role="warning" id="par_id1953489" xml-lang="en-US" l10n="NEW">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!</paragraph>
-<paragraph role="heading" id="hd_id757469" xml-lang="en-US" level="2"
l10n="NEW">Two digits years</paragraph>
-<paragraph role="paragraph" id="par_id3149720" xml-lang="en-US" l10n="U"
oldref="183">In <switchinline select="sys"><caseinline
select="MAC"><emph>%PRODUCTNAME -
Preferences</emph></caseinline><defaultinline><emph>Tools -
Options</emph></defaultinline></switchinline><emph> - $[officename] -
General</emph> you find the area <emph>Year (two digits)</emph>. This sets the
period for which two-digit information applies. Note that changes made here
have an effect on some of the following functions.</paragraph>
-<paragraph role="note" id="par_id3150654" xml-lang="en-US" l10n="U"
oldref="185">When entering dates as part of formulas, slashes or dashes used as
date separators are interpreted as arithmetic operators. Therefore, dates
entered in this format are not recognized as dates and result in erroneous
calculations. To keep dates from being interpreted as parts of formulas use the
DATE function, for example, DATE(1954;7;20), or place the date in quotation
marks and use the ISO 8601 notation, for example, "1954-07-20". Avoid using
locale dependent date formats such as "07/20/54", the calculation may produce
errors if the document is loaded under different locale settings.</paragraph>
-<paragraph role="heading" id="par_idN1067A" xml-lang="en-US" level="2"
l10n="NEW">Functions</paragraph>
+<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>
+<paragraph id="par_id1953489" role="warning" xml-lang="en-US">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!</paragraph>
+
+<paragraph id="hd_id757469" role="heading" level="2" xml-lang="en-US">Two
digits years</paragraph>
+<paragraph id="par_id3149720" role="paragraph" xml-lang="en-US">In
<switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME -
Preferences</emph>
+</caseinline><defaultinline><emph>Tools -
Options</emph></defaultinline></switchinline><emph> - $[officename] -
General</emph> you find the area <emph>Year (two digits)</emph>. This sets the
period for which two-digit information applies. Note that changes made here
have an effect on some of the following functions.</paragraph>
+<paragraph id="par_id3150654" role="note" xml-lang="en-US">When entering dates
as part of formulas, slashes or dashes used as date separators are interpreted
as arithmetic operators. Therefore, dates entered in this format are not
recognized as dates and result in erroneous calculations. To keep dates from
being interpreted as parts of formulas use the DATE function, for example,
DATE(1954;7;20), or place the date in quotation marks and use the ISO 8601
notation, for example, "1954-07-20". Avoid using locale dependent date formats
such as "07/20/54", the calculation may produce errors if the document is
loaded under different locale settings.</paragraph>
+
+<paragraph id="par_idN1067A" role="heading" level="2"
xml-lang="en-US">Functions</paragraph>
<sort order="asc">
+
<section id="workday">
-<paragraph role="paragraph" id="par_idN10683" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_workday.xhp#workday"/>
-</paragraph>
+<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 role="paragraph" id="par_id5189062" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_yearfrac.xhp#yearfrac"/>
-</paragraph>
+<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="date">
-<paragraph role="paragraph" id="par_id6854457" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_date.xhp#date"/>
-</paragraph>
+<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 role="paragraph" id="par_id6354457" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_datedif.xhp#datedif"/>
-</paragraph>
+<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 role="paragraph" id="par_id3372295" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_datevalue.xhp#datevalue"/>
-</paragraph>
+<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 role="paragraph" id="par_id5684377" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_edate.xhp#edate"/>
-</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 role="paragraph" id="par_id7576525" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_today.xhp#today"/>
-</paragraph>
+<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 role="paragraph" id="par_id641193" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_year.xhp#year"/>
-</paragraph>
+<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 role="paragraph" id="par_id6501968" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_now.xhp#now"/>
-</paragraph>
+<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 role="paragraph" id="par_id3886533" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_isoweeknum.xhp#isoweeknum"/>
-</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 role="paragraph" id="par_id3886532" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_weeknum.xhp#weeknum"/>
-</paragraph>
+<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 role="paragraph" id="par_id3886534" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo"/>
-</paragraph>
+<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 role="paragraph" id="par_id614947" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_weeknumadd.xhp#weeknumadd"/>
-</paragraph>
+<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 role="paragraph" id="par_id3953062" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_minute.xhp#minute"/>
-</paragraph>
+<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 role="paragraph" id="par_id2579729" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_month.xhp#month"/>
-</paragraph>
+<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 role="paragraph" id="par_id1346781" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_eomonth.xhp#eomonth"/>
-</paragraph>
+<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 role="paragraph" id="par_id8951384" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_networkdays.xhp#networkdays"/>
-</paragraph>
+<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"
xml-lang="en-US"><embed
href="text/scalc/01/func_networkdays.intl.xhp#networkdaysintl"/></paragraph>
+</section>
+
+<section id="workdaysintl">
+<paragraph id="par_id231020163315043955" role="paragraph"
xml-lang="en-US"><embed
href="text/scalc/01/func_workdays.intl.xhp#workdaysintl"/></paragraph>
+</section>
+
<section id="eastersunday">
-<paragraph role="paragraph" id="par_id1074251" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_eastersunday.xhp#eastersunday"/>
-</paragraph>
+<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 role="paragraph" id="par_id372325" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_second.xhp#second"/>
-</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 role="paragraph" id="par_id224005" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_hour.xhp#hour"/>
-</paragraph>
+<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 role="paragraph" id="par_id5375835" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_day.xhp#day"/>
-</paragraph>
+<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 role="paragraph" id="par_id1208838" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_days.xhp#days"/>
-</paragraph>
+<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 role="paragraph" id="par_id7679982" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_days360.xhp#days360"/>
-</paragraph>
+<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 role="paragraph" id="par_id9172643" xml-lang="en-US" l10n="NEW"
localize="false" >
- <embedvar href="text/scalc/01/func_weekday.xhp#weekday"/>
-</paragraph>
+<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 role="paragraph" id="par_id2354503" xml-lang="en-US" l10n="NEW"
localize="false">
- <embedvar href="text/scalc/01/func_time.xhp#time"/>
-</paragraph>
+<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 role="paragraph" id="par_id7765434" xml-lang="en-US" l10n="NEW"
localize="false">
- <embedvar href="text/scalc/01/func_timevalue.xhp#timevalue"/>
-</paragraph>
+<paragraph id="par_id7765434" role="paragraph" localize="false"
xml-lang="en-US"> <embedvar href="text/scalc/01/func_timevalue.xhp#timevalue"/>
</paragraph>
</section>
</sort>
+
<section id="relatedtopics">
<embed href="text/scalc/01/04060100.xhp#drking"/>
</section>
</body>
-</helpdocument>
+
+</helpdocument>
\ No newline at end of file
diff --git a/source/text/scalc/01/common_func_workdaysintl.xhp
b/source/text/scalc/01/common_func_workdaysintl.xhp
new file mode 100644
index 0000000..cc515b8
--- /dev/null
+++ b/source/text/scalc/01/common_func_workdaysintl.xhp
@@ -0,0 +1,163 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+-->
+
+<meta>
+ <topic id="textscalc01common_func_workdaysintlxml">
+ <title id="tit" xml-lang="en-US">common workdays intl</title>
+ <filename>/text/scalc/01/common_func_workdaysintl.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+
+
+<section id="embed_workdays_intl">
+<paragraph id="par_id231020162249541102" role="paragraph"
xml-lang="en-US"><emph>Weekend</emph> is an optional parameter â a number or
a string used to specify the days of the week that are weekend days and are not
considered working days. Weekend is a weekend number or string that specifies
when weekends occur. Weekend number values indicate the following weekend
days:</paragraph>
+<paragraph id="par_id231020162249545526" role="paragraph"
xml-lang="en-US">Number 1 to 7 for two-day weekends and 11 to 17 for one-day
weekends.</paragraph>
+
+<table id="Tabela1">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id231020162249542082" role="tablehead"
xml-lang="en-US">Number</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id23102016224954936" role="tablehead"
xml-lang="en-US">Weekend</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id231020162249548384" role="tablecontent"
xml-lang="en-US">1 or omitted</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231020162249544419" role="tablecontent"
xml-lang="en-US">Saturday and Sunday</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id23102016224954966" role="tablecontent"
localize="false" xml-lang="en-US">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231020162249543229" role="tablecontent"
xml-lang="en-US">Sunday and Monday</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id23102016224954344" role="tablecontent"
localize="false" xml-lang="en-US">3</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231020162249541638" role="tablecontent"
xml-lang="en-US">Monday and Tuesday</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id231020162249542340" role="tablecontent"
localize="false" xml-lang="en-US">4</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231020162249548854" role="tablecontent"
xml-lang="en-US">Tuesday and Wednesday</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id231020162249544635" role="tablecontent"
localize="false" xml-lang="en-US">5</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id23102016224954803" role="tablecontent"
xml-lang="en-US">Wednesday and Thursday</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id231020162249543818" role="tablecontent"
localize="false" xml-lang="en-US">6</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231020162249545913" role="tablecontent"
xml-lang="en-US">Thursday and Friday</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id231020162249542217" role="tablecontent"
localize="false" xml-lang="en-US">7</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231020162249546426" role="tablecontent"
xml-lang="en-US">Friday and Saturday</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id23102016224954147" role="tablecontent"
localize="false" xml-lang="en-US">11</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231020162249548630" role="tablecontent"
xml-lang="en-US">Sunday only</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id231020162249546534" role="tablecontent"
localize="false" xml-lang="en-US">12</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231020162249547536" role="tablecontent"
xml-lang="en-US">Monday only</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id231020162249542260" role="tablecontent"
localize="false" xml-lang="en-US">13</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231020162249545002" role="tablecontent"
xml-lang="en-US">Tuesday only</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id231020162249556987" role="tablecontent"
localize="false" xml-lang="en-US">14</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231020162249554939" role="tablecontent"
xml-lang="en-US">Wednesday only</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id231020162249556810" role="tablecontent"
localize="false" xml-lang="en-US">15</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231020162249558942" role="tablecontent"
xml-lang="en-US">Thursday only</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id231020162249553074" role="tablecontent"
localize="false" xml-lang="en-US">16</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231020162249558763" role="tablecontent"
xml-lang="en-US">Friday only</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id23102016224955626" role="tablecontent"
localize="false" xml-lang="en-US">17</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231020162249552635" role="tablecontent"
xml-lang="en-US">Saturday only</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+
+<paragraph id="par_id231020162249555313" role="paragraph"
xml-lang="en-US">Weekend string provides another way to define the weekly
non-working days. It must have seven (7) characters â zeros (0) for working
day and ones (1) for non-working day. Each character represents a day of the
week, starting with Monday. Only 1 and 0 are valid. â1111111â is an invalid
string and should not be used. For example, the weekend string â0000011â
defines Saturday and Sunday as non-working days.</paragraph>
+<paragraph id="par_id231020162249559739" role="paragraph"
xml-lang="en-US"><emph>Holidays</emph> is an optional list of dates that must
be counted as non-working days. The list can be given in a cell
range.</paragraph>
+</section>
+</body>
+
+</helpdocument>
\ No newline at end of file
diff --git a/source/text/scalc/01/func_networkdays.intl.xhp
b/source/text/scalc/01/func_networkdays.intl.xhp
new file mode 100644
index 0000000..11fbf61
--- /dev/null
+++ b/source/text/scalc/01/func_networkdays.intl.xhp
@@ -0,0 +1,65 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+-->
+
+<meta>
+ <topic id="textscalc01func_networkdaysintlxml">
+ <title id="tit" xml-lang="en-US">NETWORKDAYS.INTL</title>
+ <filename>/text/scalc/01/func_networkdays.intl.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+
+
+<section id="networkdaysintl_function">
+<bookmark xml-lang="en-US" branch="index" id="bm_id231020162321219565">
+ <bookmark_value>NETWORKDAYS.INTL function</bookmark_value>
+</bookmark>
+
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NETWORKDAYS_MS"
id="bm_id231020162214032558" localize="false"/>
+
+<paragraph id="hd_id231020162211573602" role="heading" level="1"
xml-lang="en-US"><variable id="networkdaysintl"><link
href="text/scalc/01/func_networkdays.intl.xhp">NETWORKDAYS.INTL</link></variable></paragraph>
+<paragraph id="par_id231020162213393086" role="paragraph"
xml-lang="en-US"><ahelp hid=".">Returns the number of workdays between a start
date and an end date. There are options to define weekend days and holidays.
The optional weekend parameter (or a string) can be used to define the weekend
days (or the non-working days in each week). Also, optionally, the user can
define a holiday list. The weekend days and user-defined holidays are not
counted as working days.</ahelp></paragraph>
+</section>
+
+<paragraph id="par_id231020162213395472" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id231020162249539143" role="paragraph"
xml-lang="en-US"><item type="literal">NETWORKDAYS.INTL(StartDate; EndDate;
Weekend; Holidays)</item></paragraph>
+<paragraph id="par_id231020162249533010" 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>
+<paragraph id="par_id231020162249536398" role="paragraph"
xml-lang="en-US"><emph>EndDate</emph> is the date up until when the calculation
is carried out. If the end date is a workday, the day is included in the
calculation.</paragraph>
+<embed href="text/scalc/01/common_func_workdaysintl.xhp#embed_workdays_intl"/>
+
+<paragraph id="hd_id231020162249551873" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id231020162249554032" role="paragraph" xml-lang="en-US">How
many workdays fall between December 15, 2016 and January 14, 2017? Let the
start date be located in C3 and the end date in D3. Cells F3 to J3 contain five
(5) holidays for Christmas and New Year in date format: December 24, 2016;
December 25, 2016; December 26, 2016; December 31, 2016; and January 1,
2017.</paragraph>
+<paragraph id="par_id231020162249551234" role="paragraph"
xml-lang="en-US"><item type="literal">=NETWORKDAYS.INTL(C3;D3;;F3:J3)</item>
returns 21 workdays with default for weekend days.</paragraph>
+<paragraph id="par_id231020162249553109" role="paragraph"
xml-lang="en-US"><item type="literal">=NETWORKDAYS.INTL(C3;D3;11;F3:J3)</item>
returns 24 workdays with Sunday only weekends.</paragraph>
+<paragraph id="par_id231020162249557786" role="paragraph"
xml-lang="en-US">Alternatively, use the weekend string â0000001â to define
Sunday as the non-working day of every week.</paragraph>
+<paragraph id="par_id231020162249553409" role="paragraph"
xml-lang="en-US"><item
type="literal">=NETWORKDAYS.INTL(C3;D3;â0000001â;F3:J3)</item> returns 24
workdays with Sunday only weekend.</paragraph>
+<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="literal">=NETWORKDAYS.INTL(C3;D3)</item> gives 22
working days.</paragraph>
+
+<section id="relatedtopics">
+<paragraph id="par_id231020162253594361" role="paragraph"
xml-lang="en-US"><link
href="text/scalc/01/func_networkdays.xhp">NETWORKDAYS</link></paragraph>
+<paragraph id="par_id241020160012187036" role="paragraph"
xml-lang="en-US"><link
href="text/scalc/01/func_workdays.intl.xhp">WORKDAYS.INTL</link></paragraph>
+<paragraph id="par_id241030160012187036" role="paragraph"
xml-lang="en-US"><link
href="text/scalc/01/func_workday.xhp">WORKDAYS</link></paragraph>
+<paragraph id="par_id23102016225717242" role="paragraph"
xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date
functions</link></paragraph>
+</section>
+</body>
+
+</helpdocument>
\ No newline at end of file
diff --git a/source/text/scalc/01/func_networkdays.xhp
b/source/text/scalc/01/func_networkdays.xhp
index c56f573..e5f4d20 100644
--- a/source/text/scalc/01/func_networkdays.xhp
+++ b/source/text/scalc/01/func_networkdays.xhp
@@ -48,6 +48,12 @@
<paragraph id="par_id3147328" role="paragraph" xml-lang="en-US"><item
type="input">=NETWORKDAYS(C3;D3;F3:J3)</item> returns 17 workdays.</paragraph>
<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">
+<paragraph id="par_id241020160012187036" role="paragraph"
xml-lang="en-US"><link
href="text/scalc/01/func_networkdays.intl.xhp">NETWORKDAYS.INTL</link></paragraph>
+<paragraph id="par_id241070160012187036" role="paragraph"
xml-lang="en-US"><link
href="text/scalc/01/func_workdays.intl.xhp">WORKDAYS.INTL</link></paragraph>
+<paragraph id="par_id241030160012187036" role="paragraph"
xml-lang="en-US"><link
href="text/scalc/01/func_workday.xhp">WORKDAYS</link></paragraph>
+<paragraph id="par_id23102016225717242" role="paragraph"
xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date
functions</link></paragraph>
+</section>
</body>
</helpdocument>
\ No newline at end of file
diff --git a/source/text/scalc/01/func_workday.xhp
b/source/text/scalc/01/func_workday.xhp
index ac8f574..93be30a 100644
--- a/source/text/scalc/01/func_workday.xhp
+++ b/source/text/scalc/01/func_workday.xhp
@@ -45,5 +45,11 @@
<paragraph role="heading" id="hd_id3150141" xml-lang="en-US" level="3"
l10n="U" oldref="193">Example</paragraph>
<paragraph role="paragraph" id="par_id3152782" xml-lang="en-US" l10n="CHG"
oldref="194">What date came 17 workdays after 1 December 2001? Enter the start
date "2001-12-01" in C3 and the number of workdays in D3. Cells F3 to J3
contain the following Christmas and New Year holidays: "2001-12-24",
"2001-12-25", "2001-12-26", "2001-12-31", "2002-01-01".</paragraph>
<paragraph role="paragraph" id="par_id3146142" xml-lang="en-US" l10n="CHG"
oldref="195">=WORKDAY(C3;D3;F3:J3) returns 2001-12-28. Format the serial date
number as a date, for example in the format YYYY-MM-DD.<comment>UFI: fixed
#i30213#</comment></paragraph>
+<section id="relatedtopics">
+<paragraph id="par_id231020162253594361" role="paragraph"
xml-lang="en-US"><link
href="text/scalc/01/func_networkdays.xhp">NETWORKDAYS</link></paragraph>
+<paragraph id="par_id241020160012187036" role="paragraph"
xml-lang="en-US"><link
href="text/scalc/01/func_networkdays.intl.xhp">NETWORKDAYS.INTL</link></paragraph>
+<paragraph id="par_id241030160012187036" role="paragraph"
xml-lang="en-US"><link
href="text/scalc/01/func_workdays.intl.xhp">WORKDAYS.INTL</link></paragraph>
+<paragraph id="par_id23102016225717242" role="paragraph"
xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date
functions</link></paragraph>
+</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_workdays.intl.xhp
b/source/text/scalc/01/func_workdays.intl.xhp
new file mode 100644
index 0000000..4f90642
--- /dev/null
+++ b/source/text/scalc/01/func_workdays.intl.xhp
@@ -0,0 +1,66 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+-->
+
+<meta>
+ <topic id="textscalc01func_workdaysxml">
+ <title id="tit" xml-lang="en-US">WORKDAYS.INTL</title>
+ <filename>/text/scalc/01/func_workdays.intl.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+
+
+<section id="workdays">
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WORKDAY_MS"
id="bm_id231020162348499245" localize="false"/>
+
+<paragraph id="hd_id231020162348002143" role="heading" level="1"
xml-lang="en-US"><variable id="workdaysintl"><link
href="text/scalc/01/func_workdays.intl.xhp">WORKDAYS.INTL</link></variable></paragraph>
+<paragraph id="par_id23102016234837285" role="paragraph"
xml-lang="en-US"><ahelp hid=".">The result is a date number that can be
formatted as a date. User can see the date of a day that is a certain number of
workdays away from the start date (before or after). There are options to
define weekend days and holidays. The optional weekend parameter (or a string)
can be used to define the weekend days (or the non-working days in each week).
Also, optionally, the user can define a holiday list. The weekend days and
user-defined holidays are not counted as working days.</ahelp></paragraph>
+</section>
+
+<paragraph id="hd_id241020160008306802" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id241020160008306838" role="paragraph"
xml-lang="en-US"><item type="literal">WORKDAY.INTL(StartDate; Days; Weekend;
Holidays)</item></paragraph>
+<paragraph id="par_id241020160008308885" 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. This is required.</paragraph>
+<paragraph id="par_id241020160008305329" role="paragraph"
xml-lang="en-US"><emph>Days</emph> is the number of workdays. Positive value
for a result after the start date, negative value for a result before the start
date.</paragraph>
+<embed href="text/scalc/01/common_func_workdaysintl.xhp#embed_workdays_intl"/>
+
+<paragraph id="hd_id241020160012172138" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id241020160012177196" role="paragraph"
xml-lang="en-US">What date comes 20 workdays after December 13, 2016? Enter the
start date in C3 and the number of workdays in D3.</paragraph>
+<paragraph id="par_id241020160012178429" role="paragraph" xml-lang="en-US">The
weekend parameter (number) may be left blank or defined as 1 for default
weekend (non-working days) â Saturday and Sunday.</paragraph>
+<paragraph id="par_id241020160012172125" role="paragraph"
xml-lang="en-US">Cells F3 to J3 contain five (5) holidays for Christmas and New
Year in date format: December 24, 2016; December 25, 2016; December 26, 2016;
December 31, 2016; and January 1, 2017.</paragraph>
+<paragraph id="par_id241020160012177923" role="paragraph"
xml-lang="en-US"><item type="literal">=WORKDAY.INTL(C3;D3;;F3:J3)</item>
returns January 11, 2017 in the result cell, say D6 (use date format for the
cell).</paragraph>
+<paragraph id="par_id24102016001217206" role="paragraph" xml-lang="en-US">To
define Friday and Saturday as weekend days, use the weekend parameter
7.</paragraph>
+<paragraph id="par_id241020160012178562" role="paragraph"
xml-lang="en-US"><item type="literal">=WORKDAY.INTL(C3;D3;7;F3:J3)</item>
returns January 15, 2017 with weekend parameter 7.</paragraph>
+<paragraph id="par_id241020160012176149" role="paragraph" xml-lang="en-US">To
define Sunday only the weekend day, use the weekend parameter 11.</paragraph>
+<paragraph id="par_id241020160012181455" role="paragraph"
xml-lang="en-US"><item type="literal">=WORKDAY.INTL(C3;D3;11;F3:J3)</item>
returns January 9, 2017.</paragraph>
+<paragraph id="par_id24102016001218469" role="paragraph"
xml-lang="en-US">Alternatively, use the weekend string â0000001â for Sunday
only weekend.</paragraph>
+<paragraph id="par_id241020160012183680" role="paragraph"
xml-lang="en-US"><item
type="literal">=WORKDAY.INTL(C3;D3;â0000001â;F3:J3)</item> returns January
9, 2017.</paragraph>
+<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="literal">=WORKDAY.INTL(C3;D3)</item> gives the
result: January 10, 2017.</paragraph>
+
+<section id="relatedtopics">
+<paragraph id="par_id231020162253594361" role="paragraph"
xml-lang="en-US"><link
href="text/scalc/01/func_networkdays.xhp">NETWORKDAYS</link></paragraph>
+<paragraph id="par_id241020160012187036" role="paragraph"
xml-lang="en-US"><link
href="text/scalc/01/func_networkdays.intl.xhp">NETWORKDAYS.INTL</link></paragraph>
+<paragraph id="par_id241030160012187036" role="paragraph"
xml-lang="en-US"><link
href="text/scalc/01/func_workday.xhp">WORKDAYS</link></paragraph>
+<paragraph id="par_id23102016225717242" role="paragraph"
xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date
functions</link></paragraph>
+</section>
+</body>
+
+</helpdocument>
\ No newline at end of file
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
