IF

[Susan]

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!

 

[Gary''s Student]

=IF(AND(A1>DATEVALUE("3/31/2009"),A1<DATEVALUE("5/1/2009")),DATEVALUE("6/15/2009"),"") and format as date.

 

[Jacob Skaria]

Another one using DATE

=IF(AND(A1>=DATE(2009,4,1),A1<=DATE(2009,4,30)),DATE(2009,6,15),"")

If this post helps click Yes

 

[Rick Rothstein]

Ignoring my attempted general solution posted elsewhere in this thread, if
you really are interested only in April dates becoming June 15th dates, then
perhaps this will do what you want...

=IF(MONTH(N1)=4,DATE(YEAR(N1),6,15),"")

 

[Rick Rothstein]

Or, if the year is important, maybe this...

=IF(AND(MONTH(A1)=4,YEAR(A1)=2009),--("6/15/2009"))