Manuals/calci/NETWORKDAYS - Revision history

Devika at 20:14, 22 August 2018

2018-08-22T20:14:28Z

2018-07-09T19:36:49Z

2018-07-09T19:36:29Z

2018-05-22T19:54:08Z

Description

2018-05-15T19:33:21Z

Description

2017-03-13T12:21:38Z

2015-05-10T16:33:07Z

2014-07-30T22:52:56Z

Examples

2014-02-04T21:55:18Z

2014-01-25T21:47:31Z

@@ Line 4: / Line 4: @@
 *'''end_date''' represents the end date, and
 *'''holidays''' is an optional range of one or more dates to exclude from the working days.
+**NETWORKDAYS() returns the number of whole workdays between two dates.
 == Description ==

← Older revision		Revision as of 19:36, 9 July 2018
Line 1:		Line 1:
−	~~=NETWORKDAYS(start_date, end_date, holidays)=~~
	<div style="font-size:30px">'''NETWORKDAYS (start_date,end_date,holidays)'''</div><br/>		<div style="font-size:30px">'''NETWORKDAYS (start_date,end_date,holidays)'''</div><br/>
	where,		where,

@@ Line 1: / Line 1: @@
 =NETWORKDAYS(start_date, end_date, holidays)=
+<div style="font-size:30px">'''NETWORKDAYS (start_date,end_date,holidays)'''</div><br/>
 where,
 *'''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.
-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 ==

@@ Line 14: / Line 14: @@
 *'''start_date''', '''end_date''' and '''holidays''' should be entered either in 'date format' or 'dates returned using formulas'.
 *If date values are invalid, Calci displays #NULL error message.
 *We can use Range values also. For Example: NETWORKDAYS(DATE(2012,6,1),#12/31/2012-12/31/2013)
 * #date notation needs  mm/dd/yy format .

@@ Line 14: / Line 14: @@
 *'''start_date''', '''end_date''' and '''holidays''' should be entered either in 'date format' or 'dates returned using formulas'.
 *If date values are invalid, Calci displays #NULL error message.
 == Examples ==

← Older revision		Revision as of 12:21, 13 March 2017
Line 61:		Line 61:
	*[http://en.wikipedia.org/wiki/Date_format_by_country Date Formats]		*[http://en.wikipedia.org/wiki/Date_format_by_country Date Formats]
	*[http://en.wikipedia.org/wiki/Calendar_date Date]		*[http://en.wikipedia.org/wiki/Calendar_date Date]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 47: / Line 47: @@
   =NETWORKDAYS(A1,A2,A3:A4):Calculates working days in the range of cells A1 and A2 and holidays in A3, A4. <br />Weekend days are excluded, A4 is overlapped with weekend day. Displays '''41''' as a result.
   =NETWORKDAYS(DATE(2012,6,1),DATE(2012,12,31)): Calculates working days between two mentioned dates. <br />Displays '''152''' as a result.
 == See Also ==

@@ Line 43: / Line 43: @@
 |}
-  =NETWORKDAYS(A1,A2): Calculates working days in the range of cells A1 and A2. Weekend days are excluded. Displays '''42''' as a result.
+  =NETWORKDAYS(A1,A2): Calculates working days in the range of cells A1 and A2. Weekend days are excluded. <br />Displays '''42''' as a result.
-  =NETWORKDAYS(A1,A2,A3): Calculates working days in the range of cells A1 and A2 and a holiday in A3. Weekend days are excluded. <br />Displays '''41''' as a result.
+  =NETWORKDAYS(A1,A2,A3): Calculates working days in the range of cells A1 and A2 and a holiday in A3. <br />Weekend days are excluded. Displays '''41''' as a result.
-  =NETWORKDAYS(A1,A2,A3:A4):Calculates working days in the range of cells A1 and A2 and holidays in A3, A4. Weekend days are excluded. <br />A4 is ovelapped with weekend day. Displays '''41''' as a result.
+  =NETWORKDAYS(A1,A2,A3:A4):Calculates working days in the range of cells A1 and A2 and holidays in A3, A4. <br />Weekend days are excluded, A4 is overlapped with weekend day. Displays '''41''' as a result.
-  =NETWORKDAYS(DATE(2012,6,1),DATE(2012,12,31)): Calculates working days between two mentioned dates. Displays '''152''' as a result.
+  =NETWORKDAYS(DATE(2012,6,1),DATE(2012,12,31)): Calculates working days between two mentioned dates. <br />Displays '''152''' as a result.
 == See Also ==

@@ Line 51: / Line 51: @@
 *[[Manuals/calci/DATE | DATE]]
-*[[Manuals/calci/WORKDAYS | WORKDAYS]]
+*[[Manuals/calci/WORKDAY | WORKDAY]]
 == References ==