WorksheetFunction.TbillEq (Excel)

Returns the bond-equivalent yield for a Treasury bill.

TbillEq (Arg1, Arg2, Arg3)

Dim dblTBillEq As Double
dblTBillEq = WorksheetFunction.TBillEq(Arg1:=, Arg2:=)


Arg1, Arg2, Arg3

Arg1 - Settlement - the Treasury bill's settlement date. The security settlement date is the date after the issue date when the Treasury bill is traded to the buyer

Arg2 - Maturity - the Treasury bill's maturity date. The maturity date is the date when the Treasury bill expires

Arg3 - Discount - the Treasury bill's discount rate