COUPPCD Function in Microsoft Excel: Syntax, Examples & Troubleshooting

=COUPPCD(settlement, maturity, frequency, [basis])

Settlement, maturity and frequency are required. Settlement is the purchase settlement date; maturity is the final maturity date. Frequency accepts 1 for annual, 2 for semiannual or 4 for quarterly coupons. The maturity date anchors the regular schedule.

Basis is optional: 0 or omitted = US (NASD) 30/360; 1 = actual/actual; 2 = actual/360; 3 = actual/365; 4 = European 30/360. Microsoft documents integer truncation of all arguments. Enter dates with DATE rather than regional text, and do not expect time-of-day fractions to define intraday coupon boundaries.

1. Enter =DATE(2026,2,15) in B2 for settlement.
2. Enter =DATE(2026,11,15) in B3 for maturity.
3. Enter 2 in B4 and 1 in B5.
4. Enter =COUPPCD(B2,B3,B4,B5) in D2 and apply a date format.

Expected date: November 15, 2025. Working backward from November 2026 in six-month steps gives May 2026 and November 2025; settlement lies between them.

A control =D2=DATE(2025,11,15) is expected to return TRUE. It compares the underlying date without depending on whether Excel displays 15-Nov-2025 or 2025-11-15. In the 1900 date system the expected serial is 45976; another date system can use a different serial for the same calendar date.

=COUPPCD(DATE(2026,2,15),DATE(2026,10,15),4,1)

Expected date: January 15, 2026. The maturity-anchored quarter dates include January, April, July and October 15. Do not calculate the previous date by simply subtracting three months from settlement; February 15 minus three months would not be a scheduled coupon date here.

For annual frequency on the original November maturity, =COUPPCD(B2,B3,1,1) returns expected November 15, 2025 as well. That agreement with the semiannual previous date is specific to this settlement; it does not make the schedules equivalent.

With the original result in D2, =B2-D2 is expected to return 92 actual calendar days. Moving settlement to March 15, 2026 leaves the previous coupon date unchanged but increases elapsed calendar days to 120.

The next regular coupon is May 15, 2026, so the complete actual period has 181 days. At the original settlement, 92 elapsed plus 89 remaining equals 181. This is an ordinary actual-date reconciliation, not a universal substitute for contractual 30/360 day-count rules.

A date output helps label a cash-flow schedule, but it does not independently identify holiday shifts, a nonstandard first coupon or an actual issuer’s payment terms. Those details are absent from this four-argument interface.

Microsoft documents #VALUE! for invalid date inputs; #NUM! for frequency outside 1,2,4, basis outside 0–4, or settlement greater than or equal to maturity. A monthly frequency of 12 is not accepted.

If a five-digit number appears, apply Date formatting rather than subtracting it from a rate or treating it as elapsed days. If the prior coupon is unexpected, check maturity and frequency before changing basis. Keep the regular-schedule assumption explicit when the actual security has irregular periods.

Microsoft’s reference checked on October 17, 2026 lists: Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016. This current support list does not establish the first release. The introduction version and last functioning version have not been established from the reviewed documentation. No retirement is asserted.

Example verification: Expected numerical results are independently calculated; text and shape expectations follow the documented contract. These examples have not been tested in Microsoft Excel. No screenshot or native execution is claimed.

DATE in Excel | DAYS in Excel | EDATE in Excel

• Microsoft COUPPCD reference, retrieved October 17, 2026.