Google Sheets
TBILLYIELD function in Google Sheets
Calculates the yield of a US Treasury Bill based on price.
=TBILLYIELD(settlement, maturity, price)TBILLYIELD 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.
- pricenumberRequired
The price at which the security is bought.
TBILLYIELD examples
Formulas you'll actually reuse.
The money-market yield of a bill bought at 98.8625:
=TBILLYIELD(DATE(2026, 3, 15), DATE(2026, 6, 14), 98.8625)Result
0.0455The yield pickup between two bills quoted in rows 2 and 3:
=TBILLYIELD(B2, C2, D2) - TBILLYIELD(B3, C3, D3)
TBILLYIELD in Excel
Same name — your formula ports as-is.
Try TBILLYIELD in the playground
Edit the example — nothing to install.
Preloaded with the TBILLYIELD formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ACCRINTCalculates the accrued interest of a security that has periodic payments.FinancialExcel
- ACCRINTMCalculates the accrued interest of a security that pays interest at maturity.FinancialExcel
- AMORLINCReturns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.FinancialExcel
- COUPDAYBSCalculates the number of days from the first coupon, or interest payment, until settlement.FinancialExcel
- COUPDAYSCalculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.FinancialExcel
- COUPDAYSNCCalculates the number of days from the settlement date until the next coupon, or interest payment.FinancialExcel