Excel Function : COUPDAYSNC

Download now!

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.