TBILLPRICE Function
Returns the price of a US Treasury bill.
Category
Financial
Available in
All versions, Microsoft 365
Returns
A price per $100 face value
Want to practice TBILLPRICE in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
Treasury bills are quoted by discount rate on an actual/360 basis. TBILLPRICE turns the quote into a price per $100.
It's 100 × (1 − discount × days ÷ 360).
Syntax
=TBILLPRICE(settlement, maturity, discount) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| settlement | Yes | The T-bill's settlement date. |
| maturity | Yes | Its maturity date — no more than one year after settlement. |
| discount | Yes | The T-bill's discount rate. |
Examples
Example 1 — Pricing a T-bill
Northstar buys a US Treasury bill settling 3/15/2026 and maturing 9/10/2026 (179 days). Quoted at a 4.2% discount.
B4fx=TBILLPRICE(B1,B2,B3)
| A | B | |
|---|---|---|
| 1 | Settlement | 3/15/2026 |
| 2 | Maturity | 9/10/2026 |
| 3 | Discount | 4.2% |
| 4 | Price | 97.91 |
Common mistakes
- #NUM! error. Maturity is more than a year after settlement, or on/before it.
Notes
- Enter dates with DATE or as cells holding real dates. Text dates like "3/15/2026" typed straight into the formula can be misread on computers with other regional settings.
- Related functions: TBILLYIELD, TBILLEQ, PRICEDISC.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.