Returns the next coupon date after the settlement date.
Syntax
COUPNCD(settlement, maturity, frequency, [basis])Argumente
settlementerforderlich
The security's settlement date.
maturityerforderlich
The security's maturity date.
frequencyerforderlich
The number of coupon payments per year (1, 2, or 4).
basisoptional
The type of day count basis to use (0-4).
The COUPNCD function calculates the date of the first coupon payment that occurs after the settlement date. It is commonly used to determine the timing of cash flows for securities such as bonds.
=COUPNCD("2023-01-25", "2025-11-15", 2, 1)→2023-05-15Calculates the next coupon date for a bond with semi-annual payments.
Enter the settlement and maturity dates
Ensure dates are entered in a format Excel recognizes, such as DATE(year, month, day).
Specify frequency and basis
Input the coupon frequency (e.g., 2 for semi-annual) and the day count basis.
The function will return a #NUM! error.