Entering dates

In Excel,dates are serial numbers.

To enter valid dates directly inside a function, you might use theDATE function.

Basis

Thebasisargument controls how days are counted.

Excel PRICE function

The PRICEMAT function allows 5 options (0-4) and defaults to zero, which specifies US 30/360basis.

Thisarticle on Wikipediaprovides a detailed explanation of available conventions.

Excel PRICEDISC function

Excel PRICEMAT function

Excel ODDFPRICE function

Excel ODDLPRICE function

Excel TBILLPRICE function