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.
A
B
C
D
1
0.03996003996004
2
3
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.
| Formula | Excel shows | Case |
|---|---|---|
=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 .