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.