COUPDAYS
Returns the number of days in the coupon period that contains the settlement date.
FinancialFinance & Accounting
What it does
Returns the total number of days in the coupon period containing the settlement date.
Syntax
COUPDAYS(settlement, maturity, frequency, [basis])
Arguments
settlement(date) — Settlement date.maturity(date) — Maturity date.frequency(number) — Coupons per year.
Examples
Days in coupon period
Count total days in the current period.
FORMULA
=COUPDAYS(DATE(2023,1,25), DATE(2023,11,15), 2, 1)
RESULT
181
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Settlement | Maturity |
| 2 | 2023-01-25 | 2023-11-15 |