MATURITY

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,

Syntax

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.
mature_date Optional.
basis Optional. A value of 0, 1, or 2. Decides the interval style that the function returns. Default is 0 if omitted.
zero_style Optional. 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.

Example 1

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.

Example 2

As at May 1st 2004, you want to perform an analysis of days to maturity on a list of outstanding creditor (liability) figures.