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