WorksheetFunction.TBillYield (Excel)
Returns the yield for a Treasury bill.
TBillYield (Arg1, Arg2, Arg3)
Dim dblTBillYield As Double
dblTBillYield = WorksheetFunction.TBillYield(Arg1:=, Arg2:=)
Arguments
Arg1, Arg2, Arg3Arg1 - 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