Manuals/calci/YEARFRAC - Revision history

Devika at 20:22, 22 August 2018

2018-08-22T20:22:52Z

Devika at 22:28, 11 July 2018

2018-07-11T22:28:20Z

Devika at 20:09, 22 May 2018

2018-05-22T20:09:26Z

Devika: /* Description */

2018-05-14T20:04:05Z

Description

Jayaram at 12:24, 13 March 2017

2017-03-13T12:24:53Z

Swapna at 02:50, 14 May 2015

2015-05-14T02:50:38Z

Swapna at 12:34, 6 February 2014

2014-02-06T12:34:02Z

Swapna at 12:32, 6 February 2014

2014-02-06T12:32:08Z

Show changes

MassBot1: Created page with "
'''YEARFRAC'''(SomeFrom, SomeTo, SomeBasis) where, '''SomeFrom''' - is a date that represents the start date. ..."

2013-10-25T02:47:41Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''YEARFRAC'''(SomeFrom, SomeTo, SomeBasis) where, '''SomeFrom''' - is a date that represents the start date. ..."

New page

<div id="6SpaceContent" class="zcontent" align="left">

'''YEARFRAC'''(SomeFrom, SomeTo, SomeBasis)

where,

'''SomeFrom''' - is a date that represents the start date.

'''SomeTo''' - is a date that represents the end date.

'''SomeBasis''' - is the type of day count

Basis          Day count

0                 US 30/360

1                 Actual/actual

2                 Actual/360

3                 Actual/365

4                 European 30/360

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

Calci calculates the fraction of the year between startdate and enddate.

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

All parameters are truncated to integers.

If SomeBasis < 0 or SomeBasis > 4, YEARFRAC

returns the #ERROR.

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

YEARFRAC

<font size="6"></font>

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

Lets see an example in (Column1, Row4)

<nowiki>=YEARFRAC(R1C1,R2C2,R3C1)</nowiki>

YEARFRAC returns 0.766667

consider an another example

<nowiki>=YEARFRAC(DATE(2008,5,4),DATE(2008,6,4),-4)</nowiki>

YEARFRAC returns #ERROR.

</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class=" " | 1/4/2008
|
| class="sshl_f SelectTD SelectTD ChangeBGColor" |
|
|- class="even"
| class=" " | Row2
| class=" " | 10/10/2008
|
|
|
|- class="odd"
| Row3
| class="sshl_f " | 4
|
|
|
|- class="even"
| Row4
| class="sshl_f" | 0.766667
|
|
|
|- class="odd"
| class=" " | Row5
|
|
|
|
|- class="even"
| Row6
|
|
|
|
|}

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

@@ Line 5: / Line 5: @@
 *<math>To</math> represents an end date, and
 *<math>Basis</math> is the type of day count basis to use.
+**YEARFRAC() calculates the fraction of the year depending on the number of days between start date and end date.
 == Description ==

@@ Line 1: / Line 1: @@
-=YEARFRAC(SD, ED, basis)=
+<div style="font-size:30px">'''YEARFRAC (From,To,Basis)'''</div><br/>
 where
-*<math>SD</math> represents a start date,
+*<math>From</math> represents a start date,
-*<math>ED</math> represents an end date, and
+*<math>To</math> represents an end date, and
-*<math>basis</math> is the type of day count basis to use.
+*<math>Basis</math> is the type of day count basis to use.
 YEARFRAC() calculates the fraction of the year depending on the number of days between start date and end date.
@@ Line 10: / Line 10: @@
 == Description ==
-YEARFRAC(SD, ED, basis)
+YEARFRAC(From,To,Basis)
 *YEARFRAC() returns the fractional proportion of the year from specified start and end dates.
-*<math>SD</math> and <math>ED</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
+*<math>From</math> and <math>To</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
-*<math>SD</math> date should be &lt; <math>ED</math>, else Calci displays NaN error message.
+*<math>From</math> date should be &lt; <math>To</math>, else Calci displays NaN error message.
-*<math>basis</math> value is optional. If omitted, Calci assumes it to be 0.
+*<math>Basis</math> value is optional. If omitted, Calci assumes it to be 0.
 *We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
-Below table shows the use of <math>basis</math> values:
+Below table shows the use of <math>Basis</math> values:
 {| class="wikitable"
@@ Line 34: / Line 34: @@
 |}
-*If <math>basis</math> value is other than 0 to 4, Calci displays #N/A error message.
+*If <math>Basis</math> value is other than 0 to 4, Calci displays #N/A error message.
 *We can use range values also.For Example :YEARFRAC(DATE(2014,1,1),#4/1/2015-4/1/2020)
 == Examples ==
-YEARFRAC(SD, ED, basis) function with inputs in order is calculated as follows:
+YEARFRAC (From,To,Basis) function with inputs in order is calculated as follows:
 <div id="2SpaceContent" class="zcontent" align="left">

@@ Line 16: / Line 16: @@
 *<math>SD</math> date should be &lt; <math>ED</math>, else Calci displays NaN error message.
 *<math>basis</math> value is optional. If omitted, Calci assumes it to be 0.
 Below table shows the use of <math>basis</math> values:
@@ Line 60: / Line 61: @@
   =YEARFRAC(DATE(2014,1,1),DATE(2014,4,1)) : Calculates the fraction Value of the year <br />within the dates mentioned. Returns '''0.25''' as a result.
   =YEARFRAC(DATE(2014,1,1),DATE(2015,4,1)) : Calculates the fraction Value of the year <br />within the dates mentioned. Returns '''1.25''' as a result.
 ==Related Videos==

← Older revision		Revision as of 20:04, 14 May 2018
Line 34:		Line 34:

	*If <math>basis</math> value is other than 0 to 4, Calci displays #N/A error message.		*If <math>basis</math> value is other than 0 to 4, Calci displays #N/A error message.
		+	*We can use range values also.For Example :YEARFRAC(DATE(2014,1,1),#4/1/2015-4/1/2020)

	== Examples ==		== Examples ==

← Older revision		Revision as of 12:24, 13 March 2017
Line 73:		Line 73:
	*[http://en.wikipedia.org/wiki/Calendar_year Calendar Year]		*[http://en.wikipedia.org/wiki/Calendar_year Calendar Year]
	*[http://en.wikipedia.org/wiki/Day_count_convention Basis Convention]		*[http://en.wikipedia.org/wiki/Day_count_convention Basis Convention]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 56: / Line 56: @@
 |}
-  =YEARFRAC(A1,A2,A3) : Calculates the fraction Value of the year with the inputs in the range A1 to A3.<br /> Returns '''0.7666666666666667''' as a result.
+  =YEARFRAC(A1,A2,A3) : Calculates the fraction Value of the year with the inputs <br />in the range A1 to A3. Returns '''0.7666666666666667''' as a result.
-  =YEARFRAC(DATE(2014,1,1),DATE(2014,4,1)) : Calculates the fraction Value of the year within the dates mentioned. <br />Returns '''0.25''' as a result.
+  =YEARFRAC(DATE(2014,1,1),DATE(2014,4,1)) : Calculates the fraction Value of the year <br />within the dates mentioned. Returns '''0.25''' as a result.
-  =YEARFRAC(DATE(2014,1,1),DATE(2015,4,1)) : Calculates the fraction Value of the year within the dates mentioned. <br />Returns '''1.25''' as a result.
+  =YEARFRAC(DATE(2014,1,1),DATE(2015,4,1)) : Calculates the fraction Value of the year <br />within the dates mentioned. Returns '''1.25''' as a result.
 == See Also ==