Google Sheets

TBILLPRICE function in Google Sheets

Calculates the price of a US Treasury Bill based on discount rate.

=TBILLPRICE(settlement, maturity, discount)

TBILLPRICE syntax and parameters

Three arguments, three required.

settlementanyRequired
The settlement date of the security, the date after issuance when the security is delivered to the buyer.
maturityanyRequired
The maturity or end date of the security, when it can be redeemed at face or par value.
discountnumberRequired
The discount rate of the bill at time of purchase.

Formulas you'll actually reuse.

Price per $100 of a 91-day T-bill quoted at a 4.5% discount:
```
=TBILLPRICE(DATE(2026, 3, 15), DATE(2026, 6, 14), 4.5%)
```
Result98.8625
The cost of a $1,000,000 face-value bill:
```
=TBILLPRICE(B2, C2, D2) * 1000000 / 100
```
Result988625

Same name — your formula ports as-is.

Edit the example — nothing to install.

Preloaded with the TBILLPRICE formula from Example 1 — change anything and watch it respond.

Loading the editor…

What they mean — and the fixes.

#NUM!
maturity is more than a year after settlement, or the discount rate is zero or negative.

More ways Google Sheets gets this done.