Excel - Microsoft Excel Tbillyield Function

Description

The Excel TBILLYIELD function calculates the yield of a Treasury Bill. 

The syntax of the function is : 

TBILLYIELD( settlement, maturity, pr ) 

Where the arguments are as follows: 

Excel Tbillyield Function Example

The following example shows the Excel Tbillyield function used to calculate the yield on a treasury bill with settlement date 01-Feb-2011, maturity date 30-Jun-2011 and a price of $99 per $100 face value: 

The Tbillyield function in the above example returns the yield 2.44%. 

Note that, as recommended, the settlement and maturity dates in the above example have been supplied to the function as references to cells containing dates. 

Tbillyield Function Errors

If you get an error from the Tbillyield function, this is likely to be one of the following: 

Common Errors