IF

[Susan]

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!

 

[Sheeloo]

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

Format B1 as DATE

 

[Rick Rothstein]

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))