Manuals/calci/WORKDAY - Revision history

Devika at 20:19, 22 August 2018

2018-08-22T20:19:34Z

Devika at 22:16, 11 July 2018

2018-07-11T22:16:36Z

Devika: /* Description */

2018-05-15T19:41:31Z

Description

Jayaram at 12:24, 13 March 2017

2017-03-13T12:24:20Z

Swapna at 02:46, 14 May 2015

2015-05-14T02:46:35Z

Swapna at 22:22, 4 February 2014

2014-02-04T22:22:14Z

Swapna at 22:17, 4 February 2014

2014-02-04T22:17:02Z

MassBot1: Created page with "
Syntax
----

2013-10-25T02:47:30Z

Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=..."

New page
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">

Syntax

</div></div>
----
<div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify">

Examples

</div></div>
----
<div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>
----
<div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">

<font size="5">Description</font>

</div></div>
----
<div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">

<font color="#484848"><font face="Arial, sans-serif"><font size="2">This function gives a number that represents a date that is the indicated number of working days before or after a date..</font></font></font>

</div></div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="6">WORKDAY</font></div></div>
----
<div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">Let's see an example in Column1Row1,Column2Row1 and Column3Row1:Column3Row3</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">C1R1=06/01/2008</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">C2R1 = 140</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">C3R1 = 10/02/2008(hdays)</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">C3R2 =10/30/2008(hday)</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">C3R3 = 08/15/2008(hdays)</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e. =WORKDAYS(C1R1,C2R1) is Sun Dec 14 00:00:00 UTC+0530 2008</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">///rly =WORKDAYS(C1R1,C2R1,C3R1:C3R3) is Tue Dec 16 00:00:00 UTC+0530 2008</font></font></font>

</div></div>
----
<div id="6SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">

''' <font color="#484848"><font face="Arial, sans-serif"><font size="2">WORKDAY</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">SD</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">dys</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,HD)</font></font></font>'''

<font color="#484848"><font face="Arial, sans-serif"><font size="2">where SD</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is a date that represents the start date and dys</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is the number of nonweekend and nonholiday days before or after start date and HD</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is an optional list of one or more dates to exclude from the working calendar.</font></font></font>

</div></div>
----
<div id="1SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class=" " | 06/01/2008
| class=" " | 140
| class="sshl_f" | 10/02/2008(hdays)
| class="sshl_f" | Sun Dec 14 00:00:00 UTC+0530 2008
|- class="even"
| class=" " | Row2
| class=" " |
| class=" " |
| class="sshl_f " | 10/30/2008(hday)
| class="sshl_f" | Tue Dec 16 00:00:00 UTC+0530 2008
|- class="odd"
| Row3
| class=" " |
| class=" " |
| class=" sshl_f " | 08/15/2008(hdays)
| class="f52543 " |
|- class="even"
| Row4
| class=" " |
| class=" " |
| class=" sshl_f " |
| class=" SelectTD" |
<div id="1Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="1Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
|- class="odd"
| class=" " | Row5
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row6
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----

@@ Line 5: / Line 5: @@
 *<math>days</math> represents the number of nonweekend and nonholiday days before or after the starting date, and
 *<math>holidays</math> is an optional list of one or more dates to exclude from the working days.
+**WORKDAY() displays the working day before or after the mentioned number of days from the starting date, excluding the weekend days and holidays.
 == Description ==

@@ Line 1: / Line 1: @@
-=WORKDAY(SD, days, holidays)=
+<div style="font-size:30px">'''WORKDAY (start_date,days,holidays)'''</div><br/>
 where,
-*<math>SD</math> represents the starting date,
+*<math>start-date</math> represents the starting date,
 *<math>days</math> represents the number of nonweekend and nonholiday days before or after the starting date, and
 *<math>holidays</math> is an optional list of one or more dates to exclude from the working days.
@@ Line 10: / Line 10: @@
 == Description ==
-WORKDAY(SD, days, holidays)
+WORKDAY(start_date, days, holidays)
-*<math>SD</math> and <math>holidays</math> should be entered either in 'date format' or 'dates returned using formulas'.
+*<math>start-date</math> and <math>holidays</math> should be entered either in 'date format' or 'dates returned using formulas'.
 *If date values are invalid, Calci displays #N/A error message.
 *Argument <math>days</math> can be positive or negative.

@@ Line 16: / Line 16: @@
 *Argument <math>days</math> can be positive or negative.
 *For positive days, Calci calculates working day after the mentioned number of days from starting date. For negative days, Calci calculates the working day before the mentioned days from the starting date.
 == Examples ==

← Older revision		Revision as of 12:24, 13 March 2017
Line 63:		Line 63:
	*[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 45: / Line 45: @@
 |}
-  =WORKDAY(A1,A2): Calculates next working day 140 days after date mentioned in A1. Weekend days are excluded. Displays '''12/12/2014''' as a result.
+  =WORKDAY(A1,A2): Calculates next working day 140 days after date mentioned in A1. <br />Weekend days are excluded. Displays '''12/12/2014''' as a result.
-  =WORKDAY(A1,A2,A3:A4):Calculates next working day 140 days after date mentioned in A1 and holidays in A3, A4. Weekend days are excluded. <br />Displays '''12/16/2014''' as a result.
+  =WORKDAY(A1,A2,A3:A4):Calculates next working day 140 days after date mentioned in A1 <br />and holidays in A3, A4. Weekend days are excluded. <br />Displays '''12/16/2014''' as a result.
-  =WORKDAY(B1,B2) : Calculates working day 30 days before the starting date mentioned in B1. Displays '''01/20/2014''' as a result.
+  =WORKDAY(B1,B2) : Calculates working day 30 days before the starting date mentioned in B1. <br />Displays '''01/20/2014''' as a result.
-  =WORKDAY(DATE(2013,6,1),60): Calculates next working day 60 days after mentioned date. Displays '''8/23/2013''' as a result.
+  =WORKDAY(DATE(2013,6,1),60): Calculates next working day 60 days after mentioned date. <br />Displays '''8/23/2013''' as a result.
 == See Also ==

@@ Line 1: / Line 1: @@
-<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
+=WORKDAY(SD, days, holidays)=
-Syntax
+where,
-</div></div>
+WORKDAY() displays the working day before or after the mentioned number of days from the starting date, excluding the weekend days and holidays.
-Examples
+== Description ==
-</div></div>
+WORKDAY(SD, days, holidays)
-<font size="5">Description</font>
+*<math>SD</math> and <math>holidays</math> should be entered either in 'date format' or 'dates returned using formulas'.
-</div></div>
+== Examples ==
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">This function gives a number that represents a date that is the indicated number of working days before or after a date..</font></font></font>
+Consider the following example that shows the use of WORKDAY function:
-</div></div>
+<div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
 | class=" " |
-| Column1
 |- class="odd"
-| class=" " | Row1
+| class="sshl_f" | 140
-| class=" " | 06/01/2008
+| class=" " | -30
-| class=" " | 140
+| class=" " |
-| class="sshl_f" | 10/02/2008(hdays)
 |- class="even"
-| class="  " | Row2
+| class=" " |8/4/2014
 | class=" " |
 | class=" " |
-| class="               sshl_f  " |
 |- class="odd"
-| class=" " | Row5
+| class=" " | 9/30/2014
 | class=" " |
 | class=" " |
 |}
-<div align="left">[[Image:calci1.gif]]</div></div>
+ =WORKDAY(A1,A2): Calculates next working day 140 days after date mentioned in A1. Weekend days are excluded. Displays '''12/12/2014''' as a result.
-----
+ =WORKDAY(A1,A2,A3:A4):Calculates next working day 140 days after date mentioned in A1 and holidays in A3, A4. Weekend days are excluded. Displays '''12/16/2014''' as a result.