Quick Answer

COUPNUM Function

Calculates the number of coupons payable between the settlement date and maturity date.

Syntax

COUPNUM

(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

Number of remaining coupon payments

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

ResultNumber of coupons remaining

For a 10-year bond purchased on April 1, 2024 with semi-annual coupons, this returns 20.

Advanced Examples

Example 1: Quarterly coupons

Corporate bond

Count quarterly coupon payments

=COUPNUM(DATE(2024,4,1), DATE(2034,4,1), 4)

Result: Number of quarterly coupons

Frequency 4 means quarterly payments.

How COUPNUM Works

COUPNUM calculates the remaining coupon payments based on the maturity date, frequency, and settlement date. It rounds up to the nearest whole coupon if settlement falls between coupon dates.

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

Frequency must be 1, 2, or 4.
Settlement must be before maturity.
Basis affects date calculations in some edge cases.

Common Errors & Fixes

#NUM! errorInvalid dates or frequency.

Fix: Verify all inputs.

#VALUE! errorDates are not recognized.

Fix: Use DATE function or valid date serial numbers.

Download Practice File

Practice COUPNUM with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the COUPNUM 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 COUPNUM and COUPNCD?

COUPNUM returns the count of remaining coupons. COUPNCD returns the date of the next coupon.

Does COUPNUM include the current coupon?

It counts all coupons from settlement to maturity, including partial periods.