Excel - Microsoft Excel Coupdaysnc Function

Description

For a security, with given conditions, the Excel COUPDAYSNC function calculates the number of days from the settlement date to the next coupon date. 

The syntax of the function is : 

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

Where the arguments are as follows: 

Note that dates for the settlement and maturity arguments should be input as either: 

• References to cells that contain dates

or 

• Dates values returned from other formulas

Warning: 

Excel Coupdaysnc Function Example

The spreadsheet below shows an example of the Excel Coupdaysnc function, used to calculate the number of days from a security's settlement date to the end of the next coupon. The security has settlement date 01-Jan-2011, maturity date 25-Oct-2012, and four payments per year. The US (NASD) 30/360 day count basis is used. 

The format of the function is shown in the left spreadsheet and the result is shown in the spreadsheet on the right. 

Coupdaysnc Function Errors

If you get an error from the Excel Coupdaysnc Function, this is most likely to be one of the following: 

Common Errors