Microsoft Office Tutorials and References
In Depth Information
Using EOMONTH to Calculate the End of the Month
Figure 11.46.
Figure 11.46. You can use
You can use EDATE
EDATE to calculate the maturity date for a se-
to calculate the maturity date for a se-
curity.
curity.
Note that EDATE can be used to back into an investment date from a maturity
date. For example, the records in rows 11 through 16 pass a negative number
for the monthsparameter.
Using
Using EOMONTH
EOMONTH to Calculate the End of the Month
to Calculate the End of the Month
Before Excel 2007, about 89 functions were available only in the Analysis
Toolpack. Some companies had rules that you were not allowed to build
spreadsheets using the functions in the Analysis Toolpack. This rule was
probably created by some corporate executive who didn t know how to turn
on the Analysis Toolpack!
One of my favorite puzzles at MrExcel.com came from someone who worked at
such a company. How can you calculate the end of the month without using
EOMONTH? This is a hard question; the end of the month is the 31st if the
month number is 1, 3, 5, 7, 8, 10, or 12. It is the 30th if the month number is 4, 6, 9,
or 11. If the month number is 2, then you have to look at the year to figure out
Search JabSto ::

Custom Search