TBILLYIELD

TBILLYIELD(settlement, maturity, price)

Returns the yield for a treasury bill.

settlement	The settlement date of the treasury bill.
maturity	The maturity date of the treasury bill.
price	The treasury bill's price per $100 face value.

REMARKS

* The "settlement" is the date when the treasury bill is traded to the buyer.
* The "maturity" is the date when the treasury bill expires.
* Dates must be entered as text strings within quotation marks or as serial numbers.
* If "settlement" is not an integer, it is truncated.
* If "settlement" > "maturity" , then #NUM! is returned.
* If "settlement" is not a valid date, then #NUM! is returned.
* If "maturity" is more than one year after "settlement", then #NUM! is returned.
* If "maturity" is not an integer, it is truncated.
* If "maturity" is not a valid date, then #NUM! is returned.
* If "price" <= 0, then #NUM! is returned.
* You can use the ODDFYIELD function to return the yield of a security with an odd first period.
* You can use the ODDLYIELD function to return the yield of a security with an odd last period.
* You can use the TBILLEQ function to return the yield (bond-equivalent) for a treasury bill.
* You can use the TBILLPRICE function to return the price per $100 face value for a treasury bill.
* You can use the YIELD function to return the interest rate (annual) for a series of equal cash flows at regular intervals.
* You can use the YIELDDISC function to return the interest rate (annual) for a discounted security (no interest payments).
* You can use the YIELDMAT function to return the interest rate (annual) for a security that pays interest at maturity.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=((100-98.949)/98.949)(360/DATEDIF*("1/1/2025", "31/3/2025", "D")) = 4.30%
2	=TBILLYIELD("1/1/2025", "31/3/2025", 98.949) = 4.30%
3	=TBILLYIELD("1/1/2025", "30/6/2025", 97.92) = 4.25%
4	=TBILLYIELD("1/1/2025", "31/12/2025", 95.976) = 4.15%
5	=TBILLYIELD("1/1/2025", "31/12/2023", 90) = #NUM!

1 - What is the yield on a 3M US Treasury bill with a price of 98.949 using a formula.
2 - What is the yield on a 3M US Treasury bill with a price of 98.949.
3 - What is the yield on a 6M US Treasury bill with a price of 97.92.
4 - What is the yield on a 1Y US Treasury bill with a price of 95.976.
5 - When the maturity date is before the settlement date.