Quick Answer

COUPNCD Function

Calculates the next coupon date after the settlement date.

Syntax

COUPNCD

(settlement, maturity, frequency, [basis])

Parameters

Parameter	Description	Required
settlement	Date the security is purchased.	Required
maturity	Date the security expires.	Required
frequency	Number of coupon payments per year (1, 2, or 4).	Required
basis	Day-count convention (0 = US 30/360, default).	Optional

Basic Example

Next coupon date for a semi-annual bond

=COUPNCD(DATE(2024,4,1), DATE(2034,4,1), 2)

ResultNext coupon date serial number

Returns the date of the next coupon payment. Format the cell as a date to see the result.

Advanced Examples

Example 1: Format the result as a date

Bond schedule

Display the next coupon date

=TEXT(COUPNCD(DATE(2024,4,1), DATE(2034,4,1), 2), "yyyy-mm-dd")

Result: Formatted next coupon date

Wraps the result in TEXT to display it as a date string.

How COUPNCD Works

COUPNCD uses the maturity date and frequency to calculate the coupon schedule and returns the first coupon date after settlement.

1

Enter settlement

Type the settlement

2

Enter maturity

Type the maturity

3

Enter frequency

Type the frequency

4

Enter basis

Type the basis

5

Calculate

Press Enter to get the result.

Important Notes & Limitations

Returns a date serial number.
Frequency must be 1, 2, or 4.
Basis affects date calculations in some edge cases.

Common Errors & Fixes

#NUM! errorInvalid dates or frequency.

Fix: Verify all inputs.

Shows as a numberThe result is a date serial number not formatted as a date.

Fix: Format the cell as a date.

Download Practice File

Practice COUPNCD with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the COUPNCD function. Works in both Excel and Google Sheets.

Works in Google SheetsCompatible with ExcelIncludes exercises

File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps

Related Functions

ACCRINT

Calculates accrued interest for a security that pays periodic interest.

ACCRINTM

Calculates accrued interest for a security that pays interest at maturity.

AMORDEGRC

Calculates depreciation for a specific period using the French declining balance method.

AMORLINC

Calculates depreciation for a specific period using the French straight-line method.

COUPDAYBS

Calculates the number of days from the beginning of the coupon period to the settlement date.

COUPDAYS

Calculates the number of days in the coupon period that contains the settlement date.

Frequently Asked Questions

What is the difference between COUPNCD and COUPPCD?

COUPNCD returns the next coupon date. COUPPCD returns the previous coupon date.

How do I display the result of COUPNCD?

Format the cell as a date or use the TEXT function.