Skip to Content

TBILLYIELD

Returns the yield for a Treasury bill

Syntax

TBILLYIELD(settlement, maturity, pr)

Parameters

  • settlement: Required. The Treasury bill's settlement date
  • maturity: Required. The Treasury bill's maturity date
  • pr: Required. The Treasury bill's price per $100 face value

Example

=TBILLYIELD("03/31/2024", "06/01/2024", 98.45)
Returns: NumberSince: Excel 2003