im a little confused on how to use that.
im looking for some thing like this, but the on columnA of sheet1 it
has a DATE and TIME

If Sheet1.Cells(a, 30) = Sheet2.Cells(6, 2) And Sheet1.Cells(a, 30)
<= Sheet2.Cells(6, 3) Then

On May 12, 8:53*am, Robert Martim, Excel wrote:
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/