Manuals/calci/YEARBASIS
YEARBASIS(Date, Basis)
where
- represents a start 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.
YEARBASIS() calculates the number of days in the year for the mentioned date with respect to basis count.
Description
YEARBASIS(Date, Basis)
- YEARBASIS() returns the number of days in the year for the mentioned date with respect to basis count.
- 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 Date} should be entered either in 'date format' or 'date returned using formula'. If date is 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 basis} value is optional. If omitted, Calci assumes it to be 0.
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.
Examples
YEARBASIS(Date, Basis) function with inputs in order is calculated as follows:
| 1/4/2008 | |
| 10/10/2008 | |
| 4 |
=YEARBASIS(A1,A3) : Calculates . Returns 360 as a result. =YEARBASIS(A2,A3) : Calculates . Returns 360 as a result. =YEARBASIS(DATE(2014,1,1),0) : Calculates . Returns 360 as a result. =YEARBASIS(DATE(2014,1,1),1) : Calculates . Returns 365 as a result. =YEARBASIS(DATE(2014,1,1),2) : Calculates . Returns 360 as a result. =YEARBASIS(DATE(2014,1,1),3) : Calculates . Returns 365 as a result. =YEARBASIS(DATE(2014,1,1)) : Calculates with Basis omitted. Returns 360 as a result.
Related Videos
See Also
References