COUPDAYSNC in Zoho Sheet: Syntax and Worked Examples

For settlement March 15, 2026, maturity January 15, 2028 and semiannual payments, the next regular coupon is July 15, 2026. COUPDAYSNC has independent expected results of 120 days under basis 0 and 122 under basis 1.

This is the remaining portion of the current coupon period. It is different from days already elapsed and from the total days in the coupon period.

=COUPDAYSNC(settlement; maturity; frequency; [basis])

Settlement is the security’s settlement/purchase date; maturity is its maturity date. Frequency is payments per year: 1, 2 or 4. Basis defaults to 0. The official mapping is 0 US/NASD 30/360, 1 actual/actual, 2 actual/360, 3 actual/365 and 4 European 30/360. The examples explicitly select 0 or 1 and use regular coupon schedules with settlement strictly between coupon dates.

Use genuine dates, for example DATE(2026;3;15), instead of ambiguous slash-separated text. Day counts are numeric results, not dates or currency amounts.

The maturity anchor and six-month spacing establish January 15/July 15 coupon dates. The next one after the stated settlement is July 15, not the final maturity date.

=COUPDAYSNC(DATE(2026;3;15);DATE(2028;1;15);2;0)
=COUPDAYSNC(DATE(2026;3;15);DATE(2028;1;15);2;1)

The basis 0 calculation for these dates is 30×(7−3)+(15−15)=120. Actual calendar time is 31+30+31+30=122 days. Both calculations start at settlement and end at the next coupon; they do not add an extra day for inclusive listing of both dates.

For a cell-based formula, enter actual dates in A2 and B2, 2 in C2 and the chosen basis in D2, then use =COUPDAYSNC(A2;B2;C2;D2).

With settlement November 15, 2026 and the same maturity/frequency, the next coupon is January 15, 2027. Independent expected remaining days are 60 under basis 0 and 61 under basis 1, from 30+31 actual days.

For quarterly frequency 4 and settlement March 15, 2026, the regular schedule includes April 15. Expected remaining days are 30 under basis 0 and 31 under basis 1. Changing frequency changes the next coupon date, not merely the label attached to an unchanged result.

For settlement March 15, 2024, the next semiannual coupon is July 15, 2024. Remaining counts are still 120 and 122 because February 29 lies before settlement. The leap day affects elapsed and full-period counts in that schedule, but not this remaining segment.

For the March 2026 semiannual example, the basis 0 period splits into elapsed 60 plus remaining 120=180. Under basis 1, elapsed 59 plus remaining 122=181. This is a useful independent check on the three related coupon-day concepts.

Do not assume the same identity with an arbitrary day-count denominator, irregular schedule or all supported basis values. A full financial model may distinguish actual elapsed/remaining days from a standardized coupon-period denominator. This guide deliberately confines numerical claims to the simple basis 0/1 schedules shown.

A day count is not a coupon payment or a forecast of when funds will arrive. Settlement conventions, business-day adjustments and instrument terms can change a real payment schedule; the simple regular maturity-anchored inputs do not encode all such terms.

The official article lists #NUM! for frequency outside 1, 2, 4, basis outside 0–4, or settlement after maturity. These are documentation-derived expectations. Equality of settlement and maturity, fractional argument conversion and month-end adjustment details are not established by the examples here.

All worked coupon dates fall on the 15th, avoiding end-of-February and 31st-day adjustment rules. Do not generalize the simple 30-day arithmetic to those boundaries, irregular first/last coupons or every basis. A security’s actual contractual schedule must be checked before applying a regular maturity-anchored model.

These formulas count days under a convention. They do not calculate a payment amount, establish eligibility for a coupon or recommend a transaction.

The official Zoho Sheet COUPDAYSNC article was checked October 18, 2026. This is rolling web-service documentation; the original introduction date, a numbered release, mobile/offline parity and a retirement endpoint are not established. The checked article does not identify the function as deprecated or retired.

All numerical results in this guide are independently calculated expectations or explicitly attributed documentation predictions. They were not executed in Zoho Sheet or its calculation engine. No native screenshot, export test or workbook run is claimed. The examples use the semicolon separators shown in Zoho’s English documentation.

• DATE
• DAYS360
• YEARFRAC