TBILLPRICE Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

=TBILLPRICE(DATE(2026,1,15),DATE(2026,4,15),0.10) is expected to return 97.5 per 100 face value. There are 90 actual days between the dates, so the formula subtracts 100×0.10×90/360=2.5 from redemption 100.

The input is an annual discount rate, measured against redemption. It is not the investment-based yield calculated from the amount paid. No basis argument is provided.

=TBILLPRICE(settlement, maturity, discount)

All three arguments are required. Use numeric dates created with DATE and a positive decimal discount rate, such as 0.10 for 10%. The official help describes maturity within one year of settlement. The inspected source checks maturity against settlement plus one calendar year, not simply an invariant 365-day count.

The calculation is 100 × (1 − discount × actual_days/360). This is a simple discount convention with normalized redemption 100. It has no frequency, coupon, custom redemption or holiday-calendar argument.

1. Enter =DATE(2026,1,15) in A2 and =DATE(2026,4,15) in B2.
2. Enter 0.10 in C2.
3. Put =TBILLPRICE(A2,B2,C2) in D2.
4. Label the result Price per 100 and use ordinary numeric formatting.

Independent calendar subtraction gives 31 days to February 15,28 to March 15 and 31 to April 15, totaling 90. The price is 100×(1−0.10×90/360)=97.5.

The last two controls span 365 and 366 actual days respectively. Both are exactly one calendar year on the chosen 15th-of-month dates. The leap-year example therefore illustrates why the source’s year limit should not be paraphrased as an unconditional 365-day maximum.

For a fictional face amount 10,000, a quote 97.5 implies a purchase amount 9,750 and a maturity principal 10,000. The gain 250 divided by the investment 9,750 is not the same percentage as 250 divided by redemption 10,000. Keep the annual discount rate and any investment-return calculation in separate columns.

The current ONLYOFFICE TBILLYIELD and TBILLEQ implementations use different internal day-count paths from TBILLPRICE. In particular, the January 15–April 15 example gives actual 90 days here but 91 in their inspected helper paths. Do not assume that combining the three functions reconstructs one perfectly consistent convention in this build. Verify the chosen measure and the destination system before relying on a cross-function check.

The source rejects settlement at/after maturity, unsupported date serials, nonpositive discount, or maturity beyond settlement plus one calendar year with #NUM! after conversion. Date serials are floored, discarding time fractions. Zero discount is rejected rather than returning 100.

There is no explicit output-positivity guard on the final price expression. A sufficiently large positive discount can make 1−discount×days/360 zero or negative. Validate a positive price factor for the intended model instead of treating every numeric output as economically meaningful.

The one-calendar-year comparison uses a date year increment; month-end and leap-day settlement anchors need their own checks. The worked cases use the 15th to avoid that ambiguity. No weekend shift, holiday adjustment, fee or market-specific quote rounding is inferred from these inputs.

Checked October 18, 2026 against the official TBILLPRICE help and official SDKJS source tagged v10.0.0.169. Desktop Editors 10.0 was released October 13, 2026. The original introduction version for this individual function is not established; current help does not mark it retired or deprecated.

All results in this guide are expected values from documentation, source inspection and independent arithmetic, not application observations. Neither the application nor its calculation engine was used to test these examples. The tag matches the installed version/build designation but does not establish identical behavior in every older release, mobile client, server deployment or imported workbook. Examples use English names and comma argument separators; adapt separators to editor settings. These fictional calculations explain a function, not an investment or borrowing recommendation.

• DATE
• DAYS