Skip to Content

TBILLEQ

Returns the bond-equivalent yield for a Treasury bill

Syntax

TBILLEQ(settlement, maturity, discount)

Parameters

  • settlement: Required. The Treasury bill's settlement date
  • maturity: Required. The Treasury bill's maturity date
  • discount: Required. The Treasury bill's discount rate

Example

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