ACCRINTM Function in ONLYOFFICE Spreadsheet Editor

• Introduction: The original introduction release is not established by the sources checked.
• Current documentation: Listed in ONLYOFFICE’s unversioned official function help, checked October 18, 2026.
• Source scope: Inspected in official SDKJS tag v10.0.0.169, commit 3679e0375a758d7dc59d31337a45461be3525ed8. This is source inspection, not proof that every deployed editor contains identical code.
• Retired or deprecated: Neither status is established; the function is documented and implemented in the inspected source.
• Testing: Examples are independently calculated or explicitly source-derived. They have not been tested in the ONLYOFFICE application or calculation engine. No native screenshot or workbook-import compatibility is claimed.

Formulas use commas and English names. If your regional settings use semicolons, replace argument separators outside quoted text. Use DATE to create financial dates rather than ambiguous text dates.

ACCRINTM calculates the interest accrued for a security that pays interest at maturity. Unlike periodic-coupon ACCRINT, it has no first-coupon date, frequency or calc_method argument. It returns interest only, not principal plus interest.

=ACCRINTM(issue, settlement, rate, par, [basis])

The source registers four through five arguments. Although help calls par optional with default 1000, the body’s empty-slot fallback does not establish that a three-argument call is accepted. Keep the par position and supply 1000 or the actual face amount. Do not copy ACCRINT’s longer argument list into this function.

1. On a fresh sheet enter =DATE(2025,1,1) in A2 and =DATE(2025,7,1) in B2.
2. Put 0.06 in C2 and 1000 in D2.
3. Enter =ACCRINTM(A2,B2,C2,D2,0) in E2.
4. The independent expected interest is 30. If principal is also repaid in full, a separate =D2+E2 calculation gives a total of 1030.

Under basis 0, the interval is 180 days of a 360-day year. The calculation is 1000 × 0.06 × 180/360. This makes clear that C2 is an annual rate: entering 6 rather than 0.06 would multiply the interest by 100.

For par 20,000, the same assumptions give interest 600 and principal-plus-interest 20,600. A security purchased at a premium or discount can have a different investment yield; ACCRINTM does not infer that yield from its face value.

The actual interval from January 1 to July 1, 2025 is 181 days. Basis 3 produces 1000 × 0.06 × 181/365, or 29.7534246575. Basis 2 produces 1000 × 0.06 × 181/360, or 30.1666666667. The day numerator is the same in those two cases, but the annual denominator changes.

The inspected implementation obtains a basis-specific numerator and a financial year-length denominator, then multiplies their ratio by par and rate. Basis 1 uses actual/actual rules rather than a universal fixed 365. On leap-year or multi-year intervals, inspect the helper’s convention and the instrument’s terms instead of transplanting the simple non-leap example.

You can build a sensitivity table with basis codes in F2:F6 and the same four financial inputs held fixed. Only use the convention required by the instrument for the final amount; the table explains differences rather than selecting whichever basis gives the largest interest.

The implementation rejects issue on or after the ending date, nonpositive rate or par, and basis outside 0–4 using its numeric-error category, conventionally #NUM!. Equal dates are therefore an error in this implementation, not a supported zero-interest example. Numeric zero is also not a valid rate or par under that guard.

Date and basis numeric inputs are floored before calculation. Use complete dates from DATE and an integer basis selector. Typed date strings may depend on language and regional parsing; these examples do not establish arbitrary text-date conversion or imported-date-system compatibility.

An error category inferred from source is not a claim that the application displayed that text in a test. Likewise, the independently expected 30 is not a native screenshot result. The selected arithmetic verifies the documented financial interpretation for explicit clean inputs while leaving coercion and file-loading behavior unclaimed.

Keep currency rounding separate from the accrued-interest equation. A cell formatted to two decimal places can display 29.75 while retaining more precision. If the contract requires rounding the payable amount itself, apply the required rounding explicitly and retain the original calculation for reconciliation.

The following are expected values, not application observations. Numeric examples use independent arithmetic; implementation-specific outputs and errors are source predictions. Keep enough displayed precision to distinguish rounding from a changed formula.

Use the exact argument order above when moving a workbook between products. Similar function names do not establish identical date calculations, validation, rounding or optional-argument handling. This guide does not certify older ONLYOFFICE releases, mobile editors or file-format round trips. The inspected definition uses the canonical name ACCRINTM; no alternate user-facing name is established here.

Use DATE for reproducible dates, YEARFRAC to explore year fractions, and ROUND for explicit monetary rounding.

• ONLYOFFICE ACCRINTM help, current unversioned function reference, checked October 18, 2026.
• Official SDKJS v10.0.0.169 implementation, pinned source for argument defaults, validation and implementation details discussed above.

These formulas calculate supplied assumptions. They do not determine a security’s contractual terms, appropriate investment choice or permitted accounting/tax treatment.