Manuals/calci/YEARFRAC

YEARFRAC(SD, ED, 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 SD} 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 ED} 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(SD, ED, basis)

• YEARFRAC() returns the fractional proportion of the year from specified start and end dates.
• $SD$ 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 ED} 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 SD} date should be < 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 ED} , 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(SD, ED, 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

• YEAR

References

• Date Formats
• Calendar Year
• Basis Convention

• List of Main Z Functions

• Z3 home