TBILLEQ Function

Returns the bond-equivalent yield of a US Treasury bill.

Category

Financial

Available in

All versions, Microsoft 365

Returns

A bond-equivalent yield

Want to practice TBILLEQ 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

T-bill discount rates use a 360-day year and face value, so they can't be compared directly with bond yields. TBILLEQ converts the discount into a bond-equivalent yield on a 365-day year.

For bills over 182 days Excel uses the longer formula that allows for a coupon bond's mid-term payment.

Syntax

=TBILLEQ(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 — Comparing a T-bill with a bond

Northstar buys a US Treasury bill settling 3/15/2026 and maturing 9/10/2026 (179 days). Discount 4.2%.

B4fx=TBILLEQ(B1,B2,B3)
AB
1Settlement3/15/2026
2Maturity9/10/2026
3Discount4.2%
4Bond-equivalent yield4.35%
5If maturing 1/10/20274.41%

Compare 4.35% — not the 4.2% quote — with a bond's YIELD.

Common mistakes

  • #NUM! error. Maturity is more than a year after settlement, or the discount is 0 or less.

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: TBILLPRICE, TBILLYIELD, YIELD.
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.