Difference between revisions of "Manuals/calci/YEARFRAC"
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | =YEARFRAC( | + | <div style="font-size:30px">'''YEARFRAC (From,To,Basis)'''</div><br/> |
where | where | ||
| − | *<math> | + | *<math>From</math> represents a start date, |
| − | *<math> | + | *<math>To</math> represents an end date, and |
| − | *<math> | + | *<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. | |
| − | YEARFRAC() calculates the fraction of the year depending on the number of days between start date and end date. | ||
== Description == | == Description == | ||
| − | YEARFRAC( | + | YEARFRAC(From,To,Basis) |
*YEARFRAC() returns the fractional proportion of the year from specified start and end dates. | *YEARFRAC() returns the fractional proportion of the year from specified start and end dates. | ||
| − | *<math> | + | *<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> | + | *<math>From</math> date should be < <math>To</math>, else Calci displays NaN error message. |
| − | *<math> | + | *<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]". | *We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]". | ||
| − | Below table shows the use of <math> | + | Below table shows the use of <math>Basis</math> values: |
{| class="wikitable" | {| class="wikitable" | ||
| Line 34: | Line 33: | ||
|} | |} | ||
| − | *If <math> | + | *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) | *We can use range values also.For Example :YEARFRAC(DATE(2014,1,1),#4/1/2015-4/1/2020) | ||
== Examples == | == Examples == | ||
| − | YEARFRAC( | + | YEARFRAC (From,To,Basis) function with inputs in order is calculated as follows: |
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
Latest revision as of 14:22, 22 August 2018
YEARFRAC (From,To,Basis)
where
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle From} represents a start date,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle To} represents an end date, and
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis}
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.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle From} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle To} dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle From} date should be < , else Calci displays NaN error message.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis} values:
| Basis | Description |
|---|---|
| 0 | US (NASD) 30/360 |
| 1 | Actual/actual |
| 2 | Actual/360 |
| 3 | Actual/365 |
| 4 | European 30/360 |
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis} 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
See Also
References