1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
<?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"/>
<h2 id="hd_id231020162211573602"><variable id="networkdaysintl"><link href="text/scalc/01/func_networkdays.intl.xhp">NETWORKDAYS.INTL</link></variable></h2>
<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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<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"/>
<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<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="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="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="input">=NETWORKDAYS.INTL(C3;D3)</item> gives 22 working days.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.NETWORKDAYS.INTL</literal></paragraph>
<section id="relatedtopics">
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
</helpdocument>
|
