# Learn How to Use Microsoft Excel COUPDAYSNC Function

Written by | 0 Comments | 318 Views

In this article, you will learn how to use the Microsoft Excel COUPDAYSNC function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel COUPDAYSNC function return value and syntax with the help of some examples.

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.