Manuals/calci/YEARFRAC

From ZCubes Wiki
Revision as of 17:28, 11 July 2018 by Devika (talk | contribs)
Jump to navigation Jump to search
YEARFRAC (From,To,Basis)


where

  • represents a start date,
  • represents an end date, and
  • 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

YEARFRAC(From,To,Basis)

  • YEARFRAC() returns the fractional proportion of the year from specified start and end dates.
  • and dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
  • date should be < , else Calci displays NaN error message.
  • 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 values:

Basis Description
0 US (NASD) 30/360
1 Actual/actual
2 Actual/360
3 Actual/365
4 European 30/360
  • If 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 (From,To,Basis) function with inputs in order is calculated as follows:

1/4/2008
10/10/2008
4
=YEARFRAC(A1,A2,A3) : Calculates the fraction Value of the year with the inputs 
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. 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. Returns 1.25 as a result. =YEARFRAC("1/1/2014[DD/MM/YYYY]","14/4/2015[DD/MM/YYYY]") = 1.2861111111111112

Related Videos

YEARFRAC

See Also

References