Practice free

TBILLYIELD function

TBILLYIELD returns the yield of a treasury bill, worked out from its price. It uses an actual-days over 360 basis, and maturity must be within a year of settlement.

Example

Read it as a sentence: find the yield on a Treasury bill from January 1, 2024 to April 1, 2024 bought at a price of 99, which gives 0.03996003996004.

Practice this in the app

Syntax

TBILLYIELD(settlement, maturity, pr)

settlement (required)
Date the security is bought (after issue, before maturity).
maturity (required)
Maturity date, no more than one year after settlement.
pr (required)
Price per 100 face value.

Returns: Yield of a treasury bill.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=TBILLYIELD(DATE(2024,3,31),DATE(2024,6,1),98.45) 0.091416963 Typical
=TBILLYIELD(DATE(2024,3,31),DATE(2025,3,31),98.45) 0.015528361 Maturity exactly 1 year
=TBILLYIELD("2024-03-31","2024-06-01",98.45) 0.091416963 Text dates
=TBILLYIELD(DATE(2024,3,31),DATE(2024,6,1),"98.45") 0.091416963 Text number value
=TBILLYIELD(DATE(2024,3,31),{45444,45500},98.45) 0.091416963 Spill
=TBILLYIELD(DATE(2024,3,31),DATE(2024,6,1),101) -0.05748962 Price > 100
=TBILLYIELD(DATE(2024,3,31),DATE(2025,4,1),98.45) #NUM! Maturity > 1 year
=TBILLYIELD(DATE(2024,3,31),DATE(2024,3,31),98.45) #NUM! Settlement = maturity

Watch out for

  • Maturity must be within a year of settlement.

Where it works

Excel
TBILLYIELD is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .