To enter valid dates directly inside a function, theDATE functionis the best option.

Backed by US government, T-Bills are considered a low risk investment.

T-Bills do not offer regular interest payments like a coupon bond.

Excel TBILLPRICE function

However, when a T-Bill matures, the owner is paid it’s par amount, or face value.

Excel TBILLEQ function

Excel TBILLYIELD function