COUPDAYSNC

How many days remain from settlement until the coupon after it.

Group: Financial. Compatible with DAX.

Syntax

COUPDAYSNC ( <settlement>, <maturity>, <frequency> [, <basis>] )

Parameter	Type	Description
`settlement`	Date	The day the buyer takes the security over; later than its issue.
`maturity`	Date	The day the security ends and its face value is repaid.
`frequency`	Whole number	Coupons a year: 1 for yearly, 2 for half-yearly, 4 for quarterly.
`basis`	Whole number optional	The day count, by number: US 30/360 (0, when left out), actual/actual (1), actual/360 (2), actual/365 (3) or European 30/360 (4).

Returns

Number. Days left until the next coupon is paid.

Remarks

On the actual bases (1, 2 and 3) it is simply the calendar days to the next coupon. On US 30/360 it is the period's length less COUPDAYBS, so the two always add up to COUPDAYS there.
The day counts: 0 and 4 count every month as 30 days (they differ only at month ends), 1 counts the actual days over the actual length of the year or coupon period, 2 the actual days over 360 and 3 the actual days over 365.
A settlement on or after maturity is an error. The dates are taken as whole days. frequency and basis are rounded to whole numbers first; a frequency other than 1, 2 or 4, or a basis outside 0 to 4, is an error.

Examples

Days to the next coupon

EVALUATE
ROW (
    "Next coupon", COUPNCD ( DATE ( 2011, 1, 25 ), DATE ( 2011, 11, 15 ), 2, 1 ),
    "Days, actual", COUPDAYSNC ( DATE ( 2011, 1, 25 ), DATE ( 2011, 11, 15 ), 2, 1 ),
    "Days, 30/360", COUPDAYSNC ( DATE ( 2011, 1, 25 ), DATE ( 2011, 11, 15 ), 2, 0 )
)

Next coupon	Days, actual	Days, 30/360
2011-05-15	110	110

COUPDAYBS, COUPDAYS, COUPNCD.

Last updated 3 November 2026 · OpenBI Studio 0.3.74