Quick Answer

COUPPCD Function

Calculates the previous coupon date before the settlement date.

Syntax

COUPPCD

(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

Previous coupon date for a semi-annual bond

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

ResultPrevious coupon date serial number

Returns the date of the coupon payment before settlement. Format the cell as a date.

Advanced Examples

Example 1: Format the result as a date

Bond schedule

Display the previous coupon date

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

Result: Formatted previous coupon date

Uses TEXT to display the date serial number as a string.

How COUPPCD Works

COUPPCD uses the maturity date and frequency to calculate the coupon schedule and returns the most recent coupon date before 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 numberResult is a date serial number.

Fix: Format the cell as a date.

Download Practice File

Practice COUPPCD with Real Data

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

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

How do I display the result of COUPPCD?

Format the cell as a date or use TEXT.