COUPDAYSNC DAX Function (Financial)
Returns the number of days from the settlement date to the next coupon date.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Settlement |
The security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. |
|
| Maturity |
The security’s maturity date. The maturity date is the date when the security expires. |
|
| Frequency |
The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4. |
|
| Basis | Optional |
The type of day count basis to use. |
Return values
Remarks
Basis sets the day-count method. Use 0 or omit the value for US (NASD) 30/360. Use 1 for actual/actual. Use 2 for actual/360. Use 3 for actual/365. Use 4 for European 30/360.
Settlement and Maturity are truncated to integers, so the time part of a date is ignored. Frequency and Basis are rounded to the nearest integer.
COUPDAYSNC returns an error in these conditions:
– Settlement or Maturity is not a valid date.
– Settlement is equal to or later than Maturity.
– Frequency is not 1, 2, or 4.
– Basis is less than 0 or greater than 4.
A BLANK Settlement does not return an error: it is treated as 30-Dec-1899 (the zero date), so the result is computed from that date.
If Settlement is a coupon date, COUPDAYSNC returns the number of days of the full coupon period to the next coupon date. With Basis 1, COUPDAYBS + COUPDAYSNC returns the same value as COUPDAYS.
Examples
-- COUPDAYBS, COUPDAYS, and COUPDAYSNC for a bond with these terms:
-- Settlement 25-Jan-2011, Maturity 15-Nov-2011
-- Frequency 2 (semiannual), coupon dates 15-May and 15-Nov
-- With Basis 1 (actual/actual), COUPDAYBS + COUPDAYSNC = COUPDAYS
EVALUATE
VAR Settlement = DATE ( 2011, 1, 25 )
VAR Maturity = DATE ( 2011, 11, 15 )
VAR Frequency = 2
RETURN
ADDCOLUMNS (
{
( 0, "US (NASD) 30/360" ),
( 1, "Actual/actual" ),
( 2, "Actual/360" ),
( 3, "Actual/365" ),
( 4, "European 30/360" )
},
"COUPDAYBS", COUPDAYBS ( Settlement, Maturity, Frequency, [Value1] ),
"COUPDAYS", COUPDAYS ( Settlement, Maturity, Frequency, [Value1] ),
"COUPDAYSNC", COUPDAYSNC ( Settlement, Maturity, Frequency, [Value1] )
)
| Value1 | Value2 | COUPDAYBS | COUPDAYS | COUPDAYSNC |
|---|---|---|---|---|
| 0 | US (NASD) 30/360 | 70 | 180.00 | 110 |
| 1 | Actual/actual | 71 | 181.00 | 110 |
| 2 | Actual/360 | 71 | 180.00 | 110 |
| 3 | Actual/365 | 71 | 182.50 | 110 |
| 4 | European 30/360 | 70 | 180.00 | 110 |
Last update: Nov 9, 2026 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/dax/coupdaysnc-function-dax