If you want to enter valid dates directly inside a function, theDATE functionis the best approach.

Basis

Thebasisargument controls how days are counted.

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

Excel formula: Bond valuation example

Thisarticle on Wikipediaprovides a detailed explanation of available conventions.

Excel PRICE function

Excel PRICEDISC function

Excel PRICEMAT function

Excel ODDFPRICE function

Excel ODDLPRICE function

Excel TBILLPRICE function