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!