WorksheetFunction.TBillYield (Excel)

Returns the yield for a Treasury bill.

TBillYield (Arg1, Arg2, Arg3)

Dim dblTBillYield As Double
dblTBillYield = WorksheetFunction.TBillYield(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 - Pr - the Treasury bill's price per $100 face value