COUPDAYBS
Returns the number of days from the beginning of the coupon period to the settlement date.
FinancialFinance & Accounting
What it does
Calculates days from the start of the coupon period until the settlement date.
Syntax
COUPDAYBS(settlement, maturity, frequency, [basis])
Arguments
settlement(date) — Settlement date.maturity(date) — Maturity date.frequency(number) — Coupons per year (1, 2, 4).
Examples
Days before settlement
Calculate days from period start.
FORMULA
=COUPDAYBS(DATE(2023,1,25), DATE(2023,11,15), 2, 1)
RESULT
71
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Settlement | Maturity |
| 2 | 2023-01-25 | 2023-11-15 |