This function is provided for the French accounting system.
Depreciation is prorated based on the date an asset is purchased in the first period.
The salvage value is $1000, and the basis is European 30/360.
To enter valid dates directly inside a function, you might use theDATE function.
Basis
Thebasisargument controls how days are counted.
The DISC function allows 5 options (0-4) and defaults to zero, which specifies US 30/360basis.
Thisarticle on wikipediaprovides a detailed explanation of available conventions.