Hello,

Having touble using the IF function with dates.

IF cell a1 has a date from and including 4/1/2009 to 4/30/2009, need the
result in cell b1 to be 6/15/2009.

Thank you everyone!

Try this in B1 with your date in A1
=IF(AND(A1=DATE(2009,4,1),A1<=DATE(2009,4,30)),DA TE(2009,6,15),"")

Format B1 as DATE
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"Susan" wrote:

Hello,

Having touble using the IF function with dates.

IF cell a1 has a date from and including 4/1/2009 to 4/30/2009, need the
result in cell b1 to be 6/15/2009.

Thank you everyone!

Assuming you simplified your question far too much, are you looking to
produce the 15th of the month that is two months hence (in other words,
7/21/2009 for example would produce 9/15/2009 as a result)? If so, try this
formula...

=IF(A1="","",DATE(YEAR(A1),MONTH(A1)+2,15))

--
Rick (MVP - Excel)


"Susan" wrote in message
...
Hello,

Having touble using the IF function with dates.

IF cell a1 has a date from and including 4/1/2009 to 4/30/2009, need the
result in cell b1 to be 6/15/2009.

Thank you everyone!