Manuals/calci/DAYSBETWEENBASIS

DAYSBETWEENBASIS (From,To,Basis)

where

• $From$ represents a start date,
• $To$ represents an end date, and
• $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.
• $From$ and $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.
• $From$ date should be < $To$, else Calci displays NaN error message.
• $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 $Basis$ values:

Basis	Description
0	US (NASD) 30/360
1	Actual/actual
2	Actual/360
3	Actual/365
4	European 30/360

• If $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

YEARFRAC

See Also

• DAYSBETWEEN
• YEARFRAC

References

• Date Formats
• Calendar Year
• Basis Convention

• List of Main Z Functions

• Z3 home