Functions

COUPDAYSNC

Days from settlement to next coupon

Try it

Use COUPDAYSNC to find the number of days from the settlement date to the next coupon payment — useful for pricing bonds between coupon dates.

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

=COUPDAYSNC(DATE(2010,2,1),DATE(2019,12,31),4) // => 59
=COUPDAYSNC(DATE(2011,1,25),DATE(2011,11,15),2,1) // => 110

COUPDAYS

Days in coupon period

COUPNCD

Next coupon date after settlement