Manuals/calci/DAYSBETWEENBASIS
Jump to navigation
Jump to search
DAYSBETWEENBASIS (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.
- DAYSBETWEENBASIS() calculates the number of days between start date and end date with respect to the count basis factor.
Description
DAYSBETWEENBASIS (From,To,Basis)
- DAYSBETWEENBASIS() returns the number of days from specified start date to end 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 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 < 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} , 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: DAYSBETWEENBASIS(#1/1/2014-2/1/2014,"4/1/2014").
- #date notation needs mm/dd/yy format .
Examples
DAYSBETWEENBASIS (From,To,Basis) function with inputs in order is calculated as follows:
| 1/4/2008 | |
| 10/10/2008 | |
| 4 |
=DAYSBETWEENBASIS(A1,A2,A3) : Calculates the days between the dates mentioned with the inputs
in the range A1 to A3 with basis count factor '4'. Returns 276 as a result. =DAYSBETWEENBASIS(DATE(2014,1,1),DATE(2014,4,1)) : Calculates the days between the dates mentioned.
Returns 90 as a result. =DAYSBETWEENBASIS(DATE(2014,1,1),DATE(2015,4,1)) : Calculates the days between the dates mentioned.
Returns 450 as a result. =DAYSBETWEENBASIS("17/6/2004[DD/MM/YYYY]","21/5/2006[DD/MM/YYYY]")= 694
Related Videos
See Also
References