Documentation/Calc Functions/COUPDAYBS

Function name:
COUPDAYBS

Category:
Financial Analysis

Summary:
Calculates the latest coupon date falling before or on the settlement date and returns the number of days between that coupon date and the settlement date.

Syntax:
COUPDAYBS(Settlement; Maturity; Frequency[; Basis])

Returns:
Returns a non-negative integer which is the count of days from the first day of interest payment on the security until the settlement date.

Arguments:
Settlement is a date or a reference to a cell containing that date which is the settlement date.

Maturity is a date or a reference to a cell containing that date which is the maturity date.

Frequency is a positive integer or a reference to a cell containing that integer which is the number of interest payments per year (1, 2 or 4).


 * If either of Settlement or Maturity is not a valid date then the function returns a value (#VALUE!) error. However, dates are essentially just numbers (search for "date and time functions" in the Help for more information).
 * If the Settlement date is on or after the Maturity date then the function reports an invalid argument error (Err:502).
 * If either Frequency or Basis is a non-integer value, then the function uses its floor value, i.e. it is truncated to an integer value.
 * After truncation if Frequency is any number except 1,2 or 4, then the function reports an invalid argument error (Err:502).
 * After truncation if Basis is any number except 0,1,2,3,4 or missing, then the function reports an invalid argument error (Err:502).

Additional details:
The function calculates back from the maturity date using the day count convention specified by the basis, and the frequency specified by the corresponding argument, finding the first coupon date falling before or on the settlement date.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/COUPDAYS COUPDAYS]

[[Special:MyLanguage/Documentation/Calc_Functions/COUPDAYSNC COUPDAYSNC]

[[Special:MyLanguage/Documentation/Calc_Functions/COUPNCD COUPNCD]

[[Special:MyLanguage/Documentation/Calc_Functions/COUPNUM COUPNUM]

[[Special:MyLanguage/Documentation/Calc_Functions/COUPPCD COUPPCD]

ODF standard:
Section 6.12.5, part 2

Equivalent Excel functions:
COUPDAYBS