=IF(AND(A1DATEVALUE("3/31/2009"),A1<DATEVALUE("5/1/2009")),DATEVALUE("6/15/2009"),"") and format as date.
--
Gary''s Student - gsnu200846


"Susan" wrote:

Hello,

Having problem using the IF function with dates.

If the date in cell A1 is from and including 4/1/2009 to 4/30/2209, the
result in B1 should be 6/15/2009.

Thank you everyone!