ACCRINT in Collabora Office: Calculate Accrued Interest Before a Periodic Coupon
Use Collabora ACCRINT with issue and first-interest dates, explicit par and frequency, reproduce the vendor control, and avoid unsupported accrual assumptions.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =ACCRINT(DATE(2001;2;28);DATE(2001;8;31);DATE(2001;5;1);10%;1000;2;0) has documented result approximately 16.94444. It calculates accrued interest for a security with periodic payments.
Syntax and required positions
=ACCRINT(Issue; FirstInterest; Settlement; Rate; [Par]; Frequency [; Basis])
Issue is the issue date. FirstInterest is the first coupon date. Settlement is the date up to which accrued interest is calculated. Rate is the annual nominal coupon rate. Frequency is required and permits 1,2,4 payments per year.
Par is optional with documented default 1000, even though a required Frequency argument follows its position. Collabora recommends always supplying Par for clarity and maintenance; every worked formula here does so. Do not shift Frequency into Par’s slot.
Basis is optional and defaults to zero. Optional brackets describe the syntax and are not typed into a working formula.
| Basis | Documented convention |
|---|---|
| 0 or omitted | US NASD, twelve 30-day months |
| 1 | Actual days in months and actual days in year |
| 2 | Actual days in months, 360-day year |
| 3 | Actual days in months, 365-day year |
| 4 | European method, twelve 30-day months |
Use DATE or genuine date cells for the inputs. A date-looking subtraction expression is not a date. The examples supply Basis explicitly and do not certify every month-end or multi-year actual/actual boundary.
The reviewed Collabora syntax has no extra calculation-method argument. Do not append one from another spreadsheet’s documentation or assume that a similarly named function has the same optional positions.
Example: reproduce the vendor’s early accrual
Enter the issue date, first-interest date, settlement date, 10%, 1000, 2, and 0 in B2:B8. Use =ACCRINT(B2;B3;B4;B5;B6;B7;B8) in B10.
The documented result is 16.94444. An independent arithmetic reconciliation is 1000×0.1×61/360=16.944444444. This identifies the 61-day equivalent implicit in the source’s US-method control; it does not establish every February/end-of-month adjustment as a general native rule.
The settlement date precedes the first coupon. The result is accrued interest at that point, not the full semiannual coupon or the security’s price.
Example: an ordinary mid-month control
Use Issue 2026-01-15, FirstInterest 2026-07-15, Settlement 2026-04-15, Rate 6%, Par 1000, Frequency 2, and Basis 0.
The independent 30/360 elapsed fraction is 90/360=0.25, so expected accrued interest is 15. The corresponding call is:
=ACCRINT(DATE(2026;1;15);DATE(2026;7;15);DATE(2026;4;15);6%;1000;2;0)
The regular semiannual coupon amount would be 1000×6%/2=30. Accrued interest halfway through that first ordinary coupon period is 15 in this independent model.
Advanced example: isolate par and rate effects
For the same ordinary dates and basis, Par 5000 gives independent accrued interest 75, while Par 1000 and Rate 3% gives 7.5. These proportional checks help diagnose an accidentally omitted par or a percentage entered on the wrong scale.
Frequency describes scheduled payments per year, not the elapsed fraction directly. Entering 6 to mean “every six months” violates the documented 1/2/4 choices; semiannual frequency is 2.
Advanced audit: keep dates and components visible
Create separate columns for Issue, FirstInterest, Settlement, annual rate, par, frequency, and basis. Add an independent day-fraction control for a simple regular-date case before applying the formula to more complicated dates.
SUM can combine separately identified amounts, and ROUND can format a reporting value. Do not add accrued interest to principal and then label the total as ACCRINT’s output; the function returns interest, not an all-in payment amount.
Errors and limitations
Check date order, explicit par, permitted frequency, and basis. The source does not enumerate all native error codes, text coercion, settlement after the first coupon, or every irregular-period algorithm. This guide’s calculated controls intentionally stay before the first coupon and do not certify those later or unusual cases.
The first example uses a vendor-documented month-end control; its independently reconstructed 61-day factor must not be generalized into an undocumented NASD algorithm. The second example avoids month-end ambiguity. A successful formula does not establish contractual accrual rules, tax treatment, or a market price.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help, retrieved and reviewed on October 17, 2026. This establishes a documentation scope, not the first release that introduced the function or the last version in which it works; those versions and any retirement date remain unestablished. Collabora Online and mobile support are not inferred from desktop help, nor is behavior in another spreadsheet product.
The examples are documentation-based expectations with independent calculations. They have not been executed in Collabora Office. No application screenshot or native error/coercion certification is implied. Formulas use English function names and semicolon argument separators.
References
- Collabora Office 26.04: ACCRINT (checked October 17, 2026).
- Editorial testing standards.