diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-08-24 15:04:36 -0300 |
|---|---|---|
| committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2018-08-27 15:51:09 +0200 |
| commit | 518f86fcc222c145c837f1e2e83e56128a30ed59 (patch) | |
| tree | f4d98fd92087355b0c6ead005de69b2fae4c5bf5 /source/text/scalc/01/func_networkdays.intl.xhp | |
| parent | tdf#117592 Collateral file trigon.ods for NL (diff) | |
| download | help-518f86fcc222c145c837f1e2e83e56128a30ed59.tar.gz help-518f86fcc222c145c837f1e2e83e56128a30ed59.zip | |
Review date and time functions help pages
fix some formatting issues
Add note and warning on date parsing
Mute l10n in some tables with constants
Change-Id: I86b4e7651ac89e2d2c8e2e658a8bdfd8f185ab60
Reviewed-on: https://gerrit.libreoffice.org/59582
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Diffstat (limited to 'source/text/scalc/01/func_networkdays.intl.xhp')
| -rw-r--r-- | source/text/scalc/01/func_networkdays.intl.xhp | 20 |
1 files changed, 7 insertions, 13 deletions
diff --git a/source/text/scalc/01/func_networkdays.intl.xhp b/source/text/scalc/01/func_networkdays.intl.xhp index 69cff76c8b..77f272f514 100644 --- a/source/text/scalc/01/func_networkdays.intl.xhp +++ b/source/text/scalc/01/func_networkdays.intl.xhp @@ -26,34 +26,29 @@ </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_id231020162249539143" role="code" xml-lang="en-US">NETWORKDAYS.INTL(StartDate; EndDate; Weekend; Holidays)</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"/> - +<embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> +<embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> <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_id231020162249551234" role="paragraph" xml-lang="en-US"><item type="input">=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="input">=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_id231020162249553409" role="paragraph" xml-lang="en-US"><item type="input">=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> - +<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"> <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">WORKDAY.INTL</link></paragraph> @@ -61,5 +56,4 @@ <paragraph id="par_id23102016225717242" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date functions</link></paragraph> </section> </body> - </helpdocument> |