ACCRINTM 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.

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

Three through five arguments are accepted. To choose a basis you must also supply par: basis is the fifth positional argument, not the fourth. The handbook calls the second date settlement; the source calls it maturity. Both refer to the same second argument here. There is no frequency parameter and no coupon-date argument. See registration and implementation.

1. Enter A1 “Issue”, A2 “End date”, A3 “Rate”, A4 “Face amount” and A5 “Basis”.
2. Enter B1 =DATE(2025;1;1), B2 =DATE(2025;7;1), B3 0.1, B4 1000 and B5 3.
3. Enter =ACCRINTM(B1;B2;B3;B4;B5) in B7.
4. Format B7 as a number with eight decimal places for comparison. Expect 49.58904110.
5. In B8 enter =B4+B7 if you need principal plus this interest. Independently expect 1049.58904110; B7 itself does not include the principal.

The mathematical control is 1000 × 0.1 × 181 / 365. Python date subtraction establishes the 181 elapsed days and ordinary arithmetic establishes the displayed expected amount. These independent calculations are separate from the selected native observations below.

For the first two cases the January-to-July interval is 180/360 under the implemented basis-0 helper. The last two use 181 actual days. Changing the basis changes the model; it is not merely a display-format choice.

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.

Build two rows with issue January 1, 2025, end date April 1, 2025 and rate 6%. The first face amount is 25,000 and the second is 40,000. Explicit basis 3 gives expected interest 369.8630136986 and 591.7808219178. Their independently expected sum is 961.6438356164.

For example, the first row formula is =ACCRINTM(DATE(2025;1;1);DATE(2025;4;1);0.06;25000;3). Use 40000 in the fourth argument for the second row. Both use the same 90/365 fraction, so the result scales in direct proportion to par. If reporting each line in cents, distinguish summing rounded lines from rounding the unrounded aggregate; those approaches need not agree in every dataset.

• The source returns #VALUE! for negative elapsed-day count, invalid basis, nonpositive par or nonpositive rate. Zero par is rejected here even though ACCRINT’s explicit checks differ.
• Equal start and end dates with otherwise valid inputs produce a zero day fraction; the source does not reject equality. Expected output for =ACCRINTM(DATE(2025;1;1);DATE(2025;1;1);0.1;1000;3) is 0, also observed in the selected 25.04.2 native test.
• A reversed ordinary interval such as July 1 to January 1 produces a negative day count and is rejected. Prefer validating the date order explicitly, especially with unusual basis-0 February adjustments.
• Use positive numeric amounts, valid dates and whole-number selectors. Text coercion, blank cells, fractional basis conversion and exact UI display of all errors have not been native-tested.
• With basis 1, crossing a leap-year boundary uses the issue year’s denominator; do not infer a calendar-year split from “actual days”.

COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETACCRINTM is an alternate registration of this function, not a distinct financial method. No duplicate alias page is proposed. Default par, date naming and errors should be rechecked after importing a workbook; matching a function name across programs does not establish matching day-count algorithms.

• YEARFRAC uses a separate implementation and must not be assumed to reproduce these helpers for every date.
• SUM totals the checked line items.
• KDE ACCRINTM handbook supplies the documented financial purpose.
• Versioned calculation and defaults provides the parameter count, defaults and explicit validation.

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 =ACCRINTM(DATE(2025;1;1);DATE(2025;7;1);0.1) and displays 50.0000000000. 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.