Natalia

You can do as follows. Suppose you have today's date on A1 and you wish to
know the last day of the month in five months' time. Instead of using
EOMONTH, you ca do as follows:

=DATE(YEAR(A1),MONTH(A1)+6,0)

By the same token, if you wish to know the EDATE in five months' time, you'd
do as follows:

=DATE(YEAR(A1),MONTH(A1)+5,DAY(A1))

--
Robert
Author of RibbonX: Customizing the Office 2007 Ribbon:
LATEST INTERACTIVE TUTORIAL:
http://www.msofficegurus.com/videos/...p_HT_Chart.asp
FORUM: http://www.msofficegurus.com/forum/