COUPDAYBS
Returns the number of days from the beginning of the coupon period to the settlement date
Syntax
COUPDAYBS(settlement, maturity, frequency, [basis])
Parameters
- settlement: Required. The security's settlement date
- maturity: Required. The security's maturity date
- frequency: Required. The number of coupon payments per year (1=annual, 2=semi-annual, 4=quarterly)
- basis: Optional. The type of day count basis to use
Example
=COUPDAYBS("01/25/2024", "11/15/2027", 2, 1)