WorksheetFunction.TBillPrice (Excel)

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

TBillPrice (Arg1, Arg2, Arg3)

Dim dblTBillPrice As Double
dblTBillPrice = WorksheetFunction.TBillPrice(Arg1:=, Arg2:=)

Arguments

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