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
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
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 — 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%.
| A | B | |
|---|---|---|
| 1 | Settlement | 3/15/2026 |
| 2 | Maturity | 9/10/2026 |
| 3 | Discount | 4.2% |
| 4 | Bond-equivalent yield | 4.35% |
| 5 | If maturing 1/10/2027 | 4.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.

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.