Entering dates

In Excel,dates are serial numbers.

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.

Excel TBILLPRICE function

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

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

When the par value is greater than the purchase price, the difference is the interest earned.

Excel TBILLEQ function

Excel TBILLYIELD function