COUPDAYBS
Category: Financial Function.
Description: Returns the number of days from the beginning of a coupon's period to the settlement date.
Syntax: COUPDAYBS(settlement, maturity, frequency, [basis])
The COUPDAYBS function syntax has the following arguments:
Settlement: security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
Maturity: security's maturity date. The maturity date is the date when security expires.
Frequency: number of coupon payments per year. Annual payments, frequency = 1; for semiannual, frequency = 2; for quaterly, frequency = 4.
Basis: type of day count basis to use.