Excel Function : COUPDAYSNC
Category
Financial
Description
Returns the number of days from the settlement date to the next coupon date
Microsoft Excel Reference Page
https://support.office.com/en-us/article/COUPDAYSNC-function-5ab3f0b2-029f-4a8b-bb65-47d525eea547
Syntax and Description of the COUPDAYSNC Excel Function
COUPDAYSNC(settlement, maturity, frequency, [basis])
About COUPDAYSNC Excel Function
COUPDAYSNC(settlement, maturity, frequency) The COUPDAYSNC function returns the number of days from the settlement date to the next coupon date, based on a 360-day year.