Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Newer edit →
Manuals/calci/NETWORKDAYS
(view source)
Revision as of 19:36, 9 July 2018
28 bytes added
,
19:36, 9 July 2018
no edit summary
Line 1:
Line 1:
=NETWORKDAYS(start_date, end_date, holidays)=
=NETWORKDAYS(start_date, end_date, holidays)=
−
+
<div style="font-size:30px">'''NETWORKDAYS (start_date,end_date,holidays)'''</div><br/>
where,
where,
*'''start_date''' represents the starting date,
*'''start_date''' represents the starting date,
Line 6:
Line 6:
*'''holidays''' is an optional range of one or more dates to exclude from the working days.
*'''holidays''' is an optional range of one or more dates to exclude from the working days.
−
NETWORKDAYS()
calculates
the number of
working days
between
'''start_date''' and '''end_date''' excluding weekends and holidays
.
+
NETWORKDAYS()
returns
the number of
whole workdays
between
two dates
.
== Description ==
== Description ==
Devika
writer
6,694
edits