Syntax: TBILLYIELD(S, M, D)
S = Settlement date
M = Maturity date
D = Discount rate of Treasury bill
TBILLYIELD returns the yield on a treasury bill, given settlement date S, maturity date M, and discount rate D. Dates must be expressed as serial date values.
Example:
TBILLYIELD(DATE(93, 4, 2), DATE(93, 7, 5), 97.585) = 0.09478
Excel function: N/A