Difference between revisions of "Manuals/calci/DAYSBETWEENBASIS"
(Created page with "=DAYSBETWEENBASIS(SD, ED, basis)= where *<math>SD</math> represents a start date, *<math>ED</math> represents an end date, and *<math>basis</math> is the type of day count b...") |
|||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =DAYSBETWEENBASIS( | + | <div style="font-size:30px">'''DAYSBETWEENBASIS (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. |
| − | + | **DAYSBETWEENBASIS() calculates the number of days between start date and end date with respect to the count basis factor. | |
| − | DAYSBETWEENBASIS() calculates the number of days between start date and end date with respect to the count basis factor. | ||
== Description == | == Description == | ||
| − | DAYSBETWEENBASIS( | + | DAYSBETWEENBASIS (From,To,Basis) |
*DAYSBETWEENBASIS() returns the number of days from specified start date to end date. | *DAYSBETWEENBASIS() returns the number of days from specified start date to end date. | ||
| − | *<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. |
| − | Below table shows the use of <math> | + | *We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]". |
| + | |||
| + | Below table shows the use of <math>Basis</math> values: | ||
{| class="wikitable" | {| class="wikitable" | ||
| Line 33: | 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: DAYSBETWEENBASIS(#1/1/2014-2/1/2014,"4/1/2014"). | ||
| + | * #date notation needs mm/dd/yy format . | ||
== Examples == | == Examples == | ||
| − | DAYSBETWEENBASIS( | + | DAYSBETWEENBASIS (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"> | ||
| Line 59: | Line 61: | ||
=DAYSBETWEENBASIS(DATE(2014,1,1),DATE(2014,4,1)) : Calculates the days between the dates mentioned. <br/>Returns '''90''' as a result. | =DAYSBETWEENBASIS(DATE(2014,1,1),DATE(2014,4,1)) : Calculates the days between the dates mentioned. <br/>Returns '''90''' as a result. | ||
=DAYSBETWEENBASIS(DATE(2014,1,1),DATE(2015,4,1)) : Calculates the days between the dates mentioned. <br/>Returns '''450''' as a result. | =DAYSBETWEENBASIS(DATE(2014,1,1),DATE(2015,4,1)) : Calculates the days between the dates mentioned. <br/>Returns '''450''' as a result. | ||
| + | =DAYSBETWEENBASIS("17/6/2004[DD/MM/YYYY]","21/5/2006[DD/MM/YYYY]")= 694 | ||
==Related Videos== | ==Related Videos== | ||
| Line 66: | Line 69: | ||
== See Also == | == See Also == | ||
| + | *[[Manuals/calci/DAYSBETWEEN | DAYSBETWEEN]] | ||
*[[Manuals/calci/YEARFRAC | YEARFRAC]] | *[[Manuals/calci/YEARFRAC | YEARFRAC]] | ||
Latest revision as of 13:49, 22 August 2018
DAYSBETWEENBASIS (From,To,Basis)
where
- represents a start date,
- represents an end date, and
- 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.
represents a start date,
represents an end date, and
is the type of day count basis to use.
Description
DAYSBETWEENBASIS (From,To,Basis)
- DAYSBETWEENBASIS() returns the number of days from specified start date to end date.
- 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: 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