ACCRINT Function (Calligra Sheets)

• Introduced: The original introduction release is not established by the inspected sources. Do not read the version checked here as the introduction date.
• Availability: Registered in Calligra Sheets 26.08.2. The relevant first-party released source was retrieved again on October 18, 2026.
• Retired or deprecated: Neither retirement nor deprecation is established by these sources; registration remains present. These terms are not interchangeable.
• Evidence: Source reviewed for 26.08.2. Selected formulas were executed in the Calligra Sheets 25.04.2 GUI on October 18, 2026 by opening the fixture XLSX, recalculating and saving ODS. The native-observation section distinguishes those results from independent expectations. This is not 26.08.2 execution or a general file-compatibility guarantee.
• Entry conventions: English function names, semicolon argument separators and decimal points. Use the installed function chooser if local entry conventions differ. Optional-argument brackets in syntax are explanatory and must not be typed.

=ACCRINT(issue; first_interest; settlement; rate; par; frequency[; basis])

The registration accepts six or seven arguments. Source validation actually accepts nonzero integer divisors of 12, rather than enforcing only the handbook’s 1, 2 and 4. That broader implementation behavior is not a recommendation to use unsupported coupon frequencies. There is no eighth calculation-method argument. Registration and implementation; calculation body.

1. In A1:B7 enter the labels and inputs below. Date constructors avoid ambiguous date text.
2. In B9 enter =ACCRINT(B1;B2;B3;B4;B5;B6;B7).
3. Display B9 with at least eight decimal places while checking. Currency formatting to two places shows 49.59 but does not change the stored value.
4. Independently count the elapsed dates: January 1 to July 1, 2025 is 181 days, excluding the start date.

Expected B9: 49.5890410958904. As a separate arithmetic control, =B5*B4*181/365 should give the same amount to normal floating-point tolerance. This is a simple-interest accrual, not a security’s total price or its compounded return.

The independent arithmetic supports the amounts. The changed-first-interest test was also executed in Calligra 25.04.2 and left the result unchanged. It is an important regression probe when switching software or versions.

Day-count basis: inspect the implementation, not only the label

The 0 and 4 helpers do not implement a general end-of-month normalization. Basis 1 does not split a multiyear interval into separate calendar-year fractions. These are material limits for month ends, February and leap-year crossings. A name such as “US 30/360” is not proof that every market convention is implemented. The examples deliberately use ordinary dates and explicit basis 3 when actual days matter. See the day-count helpers.

Suppose a face amount of 25,000 accrues at 6% from January 1 to April 1, 2025. Use =ACCRINT(DATE(2025;1;1);DATE(2025;7;1);DATE(2025;4;1);0.06;25000;2;3). The independent expectation is 369.8630136986, from 25000 × 0.06 × 90 / 365. For a ledger rounded to cents, that is 369.86. Keep the unrounded amount for reconciliation; record the chosen basis alongside the entry.

If the contract has a short or long first coupon, changing first_interest will not make this implementation prorate a coupon schedule. Establish the contract’s required method separately before using the figure in a real settlement. The example teaches the software calculation, not a market-pricing or accounting determination.

• The source returns #VALUE! for issue on or after settlement, invalid basis, zero frequency, a frequency that does not divide 12, nonpositive rate or negative par.
• Zero par differs from ACCRINTM: ACCRINT does not reject zero par in its explicit check; with other valid inputs the arithmetic predicts zero.
• The first-interest argument is required by arity even though its value is unused. Do not omit its position.
• Supply valid date values and integer frequency/basis inputs. Native behavior for invalid date text, fractional selectors and imported error values has not been established here.
• A numerical result alone does not establish compliance with a market day-count convention. Inspect month-end and leap-year cases independently.

The released Financial module registers COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETACCRINT as an alternate name for the same function. It does not need a separate tutorial. This registration is not an import/export test. Do not paste an eight-argument formula from another spreadsheet and assume that Calligra supports its extra option; the inspected registration is limited to seven.

• YEARFRAC explains a separate year-fraction function; it is not the helper used by ACCRINT.
• SUM can total independently checked accrual amounts.
• KDE ACCRINT handbook documents the interface.
• Versioned Financial source is the basis for the implementation cautions above.

The following values were observed in Calligra Sheets 25.04.2, not 26.08.2. The workbook was recalculated in the native application and saved as ODS; stored values and displayed error strings were read back from that saved workbook. Independent expected values elsewhere in this guide remain separate evidence. All other scenarios are source analysis or independent mathematics unless explicitly listed here.

Screenshot: Genuine native 25.04.2 capture. Cell B2 contains =ACCRINT(DATE(2025;1;1);DATE(2025;7;1);DATE(2025;7;1);0.1;1000;1;3) and displays 49.5890410959. Column B is the application result; column D contains fixture expectations and notes, not a second independent application run. The formula bar shows the selected formula in full.

Relevant released function source was independently compared byte-for-byte between 25.04.2 and 26.08.2. That supports the source discussion but does not turn this older-version GUI run into a 26.08.2 test. No other platform, locale, endpoint behavior or workbook round trip is certified.