Excel Function : COUPDAYBS
Category
Financial
Description
Returns the number of days from the beginning of the coupon period to the settlement date
Microsoft Excel Reference Page
https://support.office.com/en-us/article/COUPDAYBS-function-eb9a8dfb-2fb2-4c61-8e5d-690b320cf872
Syntax and Description of the COUPDAYBS Excel Function
The COUPDAYBS function in Microsoft Excel calculates the number of days before the beginning of the coupon period. The syntax for this function is as follows: COUPDAYBS(settlement, maturity, frequency, [basis]) Where: Settlement: The security's settlement date. The settlement date is the date after the issue date when the security is traded to the buyer. Maturity: The security's maturity date. This is the date when the security expires. Frequency: The number of coupon payments per year. This can be 1, 2, or 4. Basis (optional): The type of day count basis to use. This can
About COUPDAYBS Excel Function
COUPDAYBS returns the number of days from the beginning of the coupon period to the settlement date.
