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.
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.