Learn How to Use Microsoft Excel COUPDAYSNC Function

Microsoft Excel COUPDAYSNC Function

The main purpose of the Microsoft Excel COUPDAYSNC function is to get the days from settlement date to the next coupon date. That implies, with the help of the COUPDAYSNC function you can able to return the number of days from the settlement date to the next coupon date. So, with the help of the COUPDAYSNC function, you can able to get the days from the settlement date to the next coupon date.

Return Value of COUPDAYSNC Function

The return value will be the days to the next coupon date. 

Syntax of COUPDAYSNC Function

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

Where the arguments:

• settlement: This is the settlement date of the security.
• maturity: This is the maturity date of the security.
• frequency: This is the number of coupon payments per year, where annual = 1, semi-annual = 2, and quarterly = 4.
• basis: This is the day count basis, default is 0 (optional).

How to Use Microsoft Excel COUPDAYSNC Function?

So we know that Microsoft Excel COUPDAYSNC function you can able to get the days from settlement date to next coupon date. That implies, with the help of the COUPDAYSNC function you can able to return the number of days from the settlement date to the next coupon date. So, with the help of the COUPDAYSNC function, you can able to get the days from the settlement date to the next coupon date.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel