tags:

views:

14

answers:

0

In Excel, COUPNCD returns the date of the next coupon

and

COUPDAYSNC returns the number of days until the next coupon.

However, COUPNCD(settlement, maturity, freq, basis) - settlement is not always equal to

COUPDAYSNC (settlement, maturity, freq, basis)

Why is this?