Skip to Content

TBILLPRICE

Returns the price per $100 face value for a Treasury bill

Syntax

TBILLPRICE(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

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