Usage of Excel COUPDAYSNC Function in Office 365!! (With Examples)
Tags: excelcoupdaysncfunct, excelfunctions
Published: 2020-10-08 08:04:10

---
title: Usage of Excel COUPDAYSNC Function in Office 365!! (With Examples)
published: true
date: 2020-10-06 12:01:24 UTC
tags: ExcelCOUPDAYSNCFunct,ExcelFunctions
canonical_url: https://geekexcel.com/usage-of-excel-coupdaysnc-function-in-office-365-with-examples/
---

## Excel COUPDAYSNC Function:

![COUPDAYSNC Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/COUPDAYSNC-Function.png)<figcaption id="caption-attachment-15364">COUPDAYSNC Function</figcaption>

In this tutorial, you will understand the description, basic syntax, and usage of the **Excel COUPDAYSNC Function in Office 365**. Get an official version of **Microsoft Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel).
## Description of COUPDAYSNC Function:

- The Excel COUPDAYSNC Function **evaluates the number of days from the settlement date to the next coupon date**.

## COUPDAYSNC Function – Syntax:

The basic syntax of Excel COUPDAYSNC Function is,

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

### Important Note:

- Dates must be entered with the use of the [DATE function](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/). It can also be a result of other functions or formulas. If dates are entered as text, issues can occur.
- For example, use DATE(2020,7,13) for the 13th of July 2020.

### Argument Explanation:

- **Settlement (Required):** It is the settlement date of the security.
- **Maturity (Required): **It is the maturity date of the security. The maturity date is the date when the security expires.
- **Frequency (Required):** Number of coupon payments per year.
  - Annual – 1
  - Semiannual – 2
  - Quarterly – 4
- **Basis (Optional):** It specifies the day count basis to use.  

| **Basis** | **Day count basis** |
| 0 or omitted | US (NASD) 30/360 |
| 1 | Actual/actual |
| 2 | Actual/360 |
| 3 | Actual/365 |
| 4 | European 30/360 |

### Important Note:

- [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/) – Occurs if either:
  - The supplied **‘settlement’** date is greater than or equal to the **‘maturity’** date;
  - The **‘frequency’** argument is not equal to 1, 2, or 4;
  - The **‘basis’** argument is not equal to 0, 1, 2, 3, or 4.
- [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/) – Occurs if either:
  - The supplied **‘settlement’** or **‘maturity’** dates are not valid Excel dates;
  - Any of the supplied values are non-numeric characters.

## Practical Examples:

Let’s look at some examples of **COUPDAYSNC function** so you can explore how to use it in Microsoft Excel.

### Example 1:

- We have entered the input values of settlement, maturity, frequency, and basis into the cell range B5: E7.
- Here, in this example, we have selected the input cells B5, C5, D5, and E5 to calculate the number of days.
- Refer to the below syntax of the **COUPDAYSNC**  **function**  to return the output.

```
=COUPDAYSNC(B5,C5,D5,E5)
```

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-1-8.png)<figcaption id="caption-attachment-15368">Example 1</figcaption>

- You need to click **Enter** to execute the formula.

![Example 1 - Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-1-Output-7.png)<figcaption id="caption-attachment-15367">Example 1 – Output</figcaption>

- Now, you can see the result in the G5 cell.
- You can repeat the same for other input values.
- In another way, you can just drag the cell G5 to G7 so it automatically returns the respective output.

### Example 2:

- The [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/) appears if the supplied **‘settlement’** date is greater than or equal to the **‘maturity’** date or the **‘frequency’** argument is not equal to 1, 2, or 4 or the **‘basis’** argument is not equal to 0, 1, 2, 3, or 4.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/E2-3.png)<figcaption id="caption-attachment-15365">Example 2</figcaption>

### Example 3:

- The function returns the [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/) if any one of the supplied values is a non-numeric character.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/E3-3.png)<figcaption id="caption-attachment-15366">Example 3</figcaption>

## Summary:

That’s it. This article guides you to understand how to use the **EXCEL COUPDAYSNC Function in Office 365**. The description, basic syntax, and examples of this function make you understand this function even easier. Share your **valuable feedback** in the below comment box. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning With Us!!

## Read Ahead:

- **[How to use Excel ASC Function in Office 365? (With Examples)](https://geekexcel.com/how-to-use-asc-function-in-microsoft-excel-365-with-examples/)**
- **[Excel ISNONTEXT Function in Office 365 – How to use?](https://geekexcel.com/isnontext-function-in-microsoft-excel-365-how-to-use/)**
- **[How to Use Excel ISNA Function in Office 365?](https://geekexcel.com/how-to-use-isna-function-in-microsoft-excel-365/)**
- [**Use Excel ISFORMULA Function in Office 365 -Simple methods!!**](https://geekexcel.com/use-isformula-function-in-microsoft-excel-365-simple-methods/)