IF

S

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!
 
G

Gary''s Student

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

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
 
R

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),"")
 
R

Rick Rothstein

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF 2
How do I write an If(And( function using dates as my logical test? 4
Comparing dates from VLOOKUP functions not working right 2
Slope??? help please!!! 1
Date comparisons within AND() functions 2
Count if dates meet certain criteria 10
possible countif formula? 3
Extracting the latest info from 1st sheet and placing into a 2nd s 1

Top