TBILLPRICE function
TBILLPRICE returns the price per 100 of face value for a treasury bill, worked out from its discount rate. It uses an actual-days over 360 convention.
Example
Read it as a sentence: find the price per $100 of face value for a Treasury bill from January 1, 2024 to April 1, 2024 at a 4 percent discount rate, which gives 98.9888888888889.
A
B
C
D
1
98.9888888888889
2
3
Syntax
TBILLPRICE(settlement, maturity, discount)
-
settlement(required) - Date the security is bought (after issue, before maturity).
-
maturity(required) - Maturity date, no more than one year after settlement.
-
discount(required) - Treasury bill discount rate.
Returns: Price per 100 face value 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 |
|---|---|---|
=TBILLPRICE(DATE(2024,3,31),DATE(2024,6,1),0.09) | 98.45 | Typical |
=TBILLPRICE(DATE(2024,3,31),DATE(2025,3,31),0.09) | 90.875 | Maturity exactly 1 year |
=TBILLPRICE("2024-03-31","2024-06-01",0.09) | 98.45 | Text dates |
=TBILLPRICE(DATE(2024,3,31),DATE(2024,6,1),"0.09") | 98.45 | Text number value |
=TBILLPRICE(DATE(2024,3,31),{45444,45500},0.09) | 98.45 | Spill |
=TBILLPRICE(DATE(2024,3,31),DATE(2025,4,1),0.09) | #NUM! | Maturity > 1 year |
=TBILLPRICE(DATE(2024,3,31),DATE(2024,3,31),0.09) | #NUM! | Settlement = maturity |
=TBILLPRICE(DATE(2024,6,1),DATE(2024,3,31),0.09) | #NUM! | Settlement after maturity |
Watch out for
- Maturity must be within a year of settlement.
Where it works
- Excel
- TBILLPRICE 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 .