Work out the number of days between a date and the maturity date, and represent it in form of intervals (Stratification).
This function is especially useful in the field of Accounting and Finance. For instance,
MATURITY(start_date, mature_date, basis, zero_style
|start_date||string expression (or the reference to a cells) from which all spaces are to be removed.|
A value of 0, 1, or 2. Decides the interval style that the function returns.
Default is 0 if omitted.
A value of 0, 1, or 2. Decides what answer will be returned if maturity_date
minus start_date is less than 0. (see table above). Default is 0 if omitted.
As at May 1st 2004, you want to perform a debtor aging analysis on the debtors account:
In the above example, some optional parameters were omitted in the function. Default values were used automatically. Optional parameter zero_style has been assigned a value of 2, so that for debts not yet due, the answer of “Not Due” is returned.
As at May 1st 2004, you want to perform an analysis of days to maturity on a list of outstanding creditor (liability) figures.