COUPNCD Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

COUPNCD returns the next coupon date strictly after settlement. =COUPNCD(DATE(2026,4,15),DATE(2028,12,15),2,1) is expected to represent June 15, 2026. In a 1900-date-system workbook, its raw numeric serial is 46188. A date format changes the display, not the stored result.

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

The official COUPNCD reference lists basis 0 as US (NASD) 30/360, 1 as actual/actual, 2 as actual/360, 3 as actual/365 and 4 as European 30/360. Brackets indicate an optional argument; do not type them. Use integer frequency and basis values deliberately rather than relying on input conversion.

These functions infer a regular schedule from maturity and frequency. They do not take an issue date, first coupon date, holiday calendar or irregular-period flag. A contractual payment schedule with odd first/last coupons or business-day adjustments needs separate treatment.

Enter the following in a new worksheet. DATE avoids ambiguity between month/day and day/month date text.

Put =COUPNCD(A2,B2,C2,D2) in E2. The expected regular schedule around settlement runs from December 15, 2025 to June 15, 2026. All examples in this guide are documentation/source-derived expectations with independent calendar arithmetic; none was tested in the application or its calculation engine.

After entering the setup, format E2 as General or Number to inspect its expected raw result 46188. Put =E2 in F2 and apply a date format such as yyyy-mm-dd; F2 should represent 2026-06-15. These are two views of the same numeric date value, not separate outputs from COUPNCD.

Annual coupons retain maturity’s December anchor. Semiannual coupons fall in June and December; quarterly coupons include March, June, September and December. April settlement is followed by June in both latter schedules.

At an exact coupon boundary, =COUPNCD(DATE(2026,6,15),B2,2,1) is expected to return December 15, 2026, serial 46371. The next-coupon helper advances until its candidate is strictly greater than settlement.

Basis is accepted and validated, but the date helper receives settlement, maturity and frequency without basis. The worked date is therefore unchanged across valid basis codes 0–4 in the inspected source; changing basis does not shift a coupon onto a business day.

For a fictional payment calendar, retain the raw numeric coupon date for comparisons and use a separate formatted column for display. To independently check the worked next date, calendar subtraction gives June 15 minus April 15 = 61 actual days. This can be checked against the corresponding actual-basis duration, but it is not the same as adding a 30/360 day count to settlement.

The function has no holiday list or weekend rule. If a contract pays on a following business day, preserve both the nominal coupon date and the separately adjusted payment date. Do not silently move the nominal schedule anchor; doing so can change later periods. Irregular first/last payments cannot be specified with these four arguments.

The 10.0.0.169 coupon wrappers floor numeric date serials, frequency and basis before validation. Thus a time fraction is discarded. This does not mean malformed text or fractional settings are recommended inputs.

• Settlement equal to or later than maturity returns #NUM! in the inspected source. For example, with A2 and B2 from the setup, =COUPNCD(B2,B2,2,1) follows that guard.
• An unsupported frequency such as 3 or basis such as 5 returns #NUM! after integer conversion.
• Boolean scalar arguments and multi-cell ranges are rejected with #VALUE! in these wrappers. Use individual input cells.
• An empty required scalar input is handled as #N/A; omitted basis defaults to 0. Do not assume a blank referenced basis cell has the same treatment as omitting the argument.
• Dates before the supported serial range and locale-dependent date-text coercion require separate checking. The examples use modern DATE values rather than historical serial edge cases.

Month-end and leap-day schedules deserve special attention. The date helper preserves month end when adding months from a month-end date, while year changes use a UTC year setter. A February 29 maturity and an arbitrary month-end sequence should therefore be checked against the contract rather than inferred from a fixed number of days. The 15th-of-month examples avoid those edge cases. No holiday or weekend adjustment is made by the inspected coupon helpers.

Checked October 18, 2026 against the current official help and SDKJS source tagged v10.0.0.169. Desktop Editors 10.0 was released October 13, 2026. The sources do not establish this function’s first introduction version, and do not mark it retired or deprecated.

The source tag matches the installed version/build designation; it does not establish native execution or byte-for-byte identity of the entire application. Older versions, mobile clients, server deployments and imported-workbook behavior were not tested. Formula examples use English names and comma separators; adapt separators to your editor’s settings. Date serial examples, where shown, assume the 1900 date system; a different workbook date system changes the raw serial, not the intended calendar label.

• DATE
• DAYS