writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + Line 10:
Line 10: − + − + − + − + − + Line 35:
Line 35: − + Line 41:
Line 41: − +
no edit summary
=DAYSBETWEENBASIS(SD, ED, basis)=
=DAYSBETWEENBASIS(SD, ED, basis)=
<div style="font-size:30px">'''DAYSBETWEENBASIS (From,To,Basis)'''</div><br/>
where
where
*<math>SD</math> represents a start date,
*<math>From</math> represents a start date,
*<math>ED</math> represents an end date, and
*<math>To</math> represents an end date, and
*<math>basis</math> is the type of day count basis to use.
*<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(SD, ED, basis)
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>SD</math> and <math>ED</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>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>SD</math> date should be < <math>ED</math>, else Calci displays NaN error message.
*<math>From</math> date should be < <math>To</math>, else Calci displays NaN error message.
*<math>basis</math> value is optional. If omitted, Calci assumes it to be 0.
*<math>Basis</math> 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]".
*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:
Below table shows the use of <math>Basis</math> values:
{| class="wikitable"
{| class="wikitable"
|}
|}
*If <math>basis</math> value is other than 0 to 4, Calci displays #N/A error message.
*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").
*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 .
* #date notation needs mm/dd/yy format .
== Examples ==
== Examples ==
DAYSBETWEENBASIS(SD, ED, basis) function with inputs in order is calculated as follows:
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">