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

ArgumentRequired?What it does
settlementYesThe T-bill's settlement date.
maturityYesIts maturity date — no more than one year after settlement.
discountYesThe 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)
AB
1Settlement3/15/2026
2Maturity9/10/2026
3Discount4.2%
4Price97.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.
Kyle Stott

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.