Entering dates
In Excel,dates are serial numbers.
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.
Thisarticle on Wikipediaprovides a detailed explanation of available conventions.
