How to use the COUPNCD Function in Excel office 365?
Tags: tousethecoupncdfunct, excel, excelfunctions
Published: 2021-08-25 09:30:13

---
title: How to use the COUPNCD Function in Excel office 365?
published: true
date: 2021-08-22 15:04:22 UTC
tags: ToUseTheCOUPNCDFunct,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-coupncd-function-in-excel-office-365/
---

 **COUPNCD function** returns the **next date of coupon** to be used from the **settlement date to the next coupon date**. This happens after when the security is traded to the buyer. In this tutorial, we will guide you on **how to use the COUPNCD Function In Excel Office 365**. Let’s get them below!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## COUPNCD Function Syntax

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

**Syntax Explanation:**

- **settlement date** : security settlement date after the issue date when the security is traded to the buyer.
- **maturity date** : first period end date.
- **Frequency** : number of payments per year (annual = 1, semi-annual = 2, quarterly = 4).
- **[basis]** – [optional] Day count basis. Default is 0.

## Example

- Firstly, you have to **create the data** with **value and argument**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-24.png)<figcaption>Sample data</figcaption>

- Then, you need to perform the **COUPNCD function** over values and significance with the **numbers**.
- Now, you have to use the **formula** given below.

```
= COUPNCD( A2 ,A3 ,A4 ,A5 )
```

**Explanation:**

- **A2** : settlement date in A2 cell.
- **A3** : maturity date in A3 cell.
- **A4** : Frequency in A4 cell.
- **A5** : [basis] value in A5 cell.

![](https://geekexcel.com/wp-content/uploads/2021/08/COUPNCD-function-1024x390.png)<figcaption>COUPNCD function</figcaption>

- After that, all the **arguments** to the function are given as **cell references** and press  **Enter ** to get the **next coupon date**.
- You need to use the **DATE function**  with **COUPNCD function** to give a **date argument**.
- Then, you have to use the following **formula** given below.

```
=COUPNCD(DATE ( 2019 ,3 ,1 ),DATE (2025 ,12 ,31 ) ,A4 ,A5)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/DATE-function-1024x347.png)<figcaption>DATE function</figcaption>

- Now, you need to see the **COUPNCD function** when used with the **DATE function** in a formula returns the **same result**.

**Check this too:** [How to use the FVSCHEDULE function in Excel Office 365?](https://geekexcel.com/how-to-use-the-fvschedule-function-in-excel-office-365/)

**NOTES:**

- Excel stores **dates as serial numbers** and is used in calculation by the **function**.
- It is used to recommend to use **dates as cell reference** instead of giving **direct argument to the function**.
- Now, the arguments like **settlement date & maturity date** , **basis** are truncated to **integers**.
- After that, the function returns the **#VALUE! Error** if the **settlement date & maturity date** is not a **valid date format**.
- The function returns the **#NUM! Error** if:
  - frequency can take **integer values** and cannot be **less than 1**.
  - If **basis argument** is either.

## Verdict

We hope that this tutorial gives you guidelines on **how to use the COUPNCD Function In Excel Office 365. ** Please leave a comment in case of any **queries,** and don’t forget to mention your valuable **suggestions** as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Further Reference:**

- **[How to use the TBILLPRICE function in Excel Office 365?](https://geekexcel.com/how-to-use-the-tbillprice-function-in-excel-office-365/)**
- **[How to use the TBILLYIELD function in Excel office 365?](https://geekexcel.com/how-to-use-the-tbillyield-function-in-excel-office-365/)**
- **[Find the Last Column of Data in Excel Office 365](https://geekexcel.com/how-to-find-the-last-column-of-data-in-excel-office-365/)**