TBILLPRICE

The TBILLPRICE function returns the price per $100 face value for a Treasury bill, based on a settlement date, a maturity date, and a discount. In the example shown, the settlement date is 5-Feb-2019, the maturity date is 1-Feb-2020, and the discount is 2.45%. The formula in F5 is: With these inputs, the TBILLPRICE function returns a price per $100 of $97.54, with currency number format applied. To convert the face value of $1000 in cell C5 to a price using the value returned by TBILLPRICE, F6 contains this formula: In Excel, dates are serial numbers. Generally, the best way to enter valid dates is to use cell references, as shown in the example. To enter valid dates directly inside a function, the DATE function is the best option. A treasury bill (also called a T-Bill) is a short-term deb