Microsoft Office Tutorials and References
In Depth Information
EOMONTH
maturity is in cell C8, thus the result would equal 4/16/1999. A –1 would result in the date
2/16/1999. The second example in cell D18 uses a text date entr y and the months to maturity
is 7, resulting in the date 10/16/1999. Note that because this function returns a serial
number, you may have to apply a date format to the cell containing the formula.
The start date to maturity.
START DATE
A
Cell reference
Figure 4.4
The EDATE function
calculates the maturity
date or date due that
falls on the same day
of the month as the
date of issue.
C
Mature date
B Text entry
D
Months
EOMONTH
EOMONTH r eturns the calculated maturity dates or dates due that fall in the last day of the
month.
=EOMONTH(start_date,months)
The EOMONTH function operates similar to the EDATE function and the syntax is the same,
however, the calculation of the maturity date falls on the last day of the month. For example:
The start date to maturity.
START DATE
This is the number of months to maturity from the start date. If a
negative number, it returns a past date.
MONTHS
For example:
=EOMONTH(“3/16/99”,1) results in a maturity date of 4/30/99
=EOMONTH(“3/16/99”,2) results in a maturity date of 5/31/99
=EOMONTH(“3/16/99”,3) results in a maturity date of 6/30/99
And so on.
Search JabSto ::

Custom Search