IF Function

[JEA]

Hi All,
I was asked to come up with what I thought was a simple solution to a complex problem. I have a date in cell A1. The results are shown in A3. If the cell in A1 is before 9/29/10, the results in A3 is false. If the date in A1 is between 9/29/10 and 10/1/11, the results are true.
Here's what I tried:
=IF(H12<"9/28/10","Y","N")*IF(AND(H12>="9/29/10",H12<="10/1/11"),"Y","N")
Since I am asking for help, this obviously didn't work.

Any help will be greatly appreciated.

Thanks:

[6StringJazzer]

What result do you want if the date is after 10/1/11?

Well, anyway, try this:

=IF(AND(DATE(2010,9,29)<=A1,A1<=DATE(2011,10,1)),"Y","N")

[JEA]

Thanks...after 10/1/11, the results should be N

N Before 9/28/10
Y Between 9/29/10 and 9/30/11
N After 10/1/11

Thanks again

[JEA]

I got some good help last night but still have one last glich. I need a formula that will return a N if the date entered in A1 is on or before 9/28/10. If the date entered in A1 is on 9/29/10 and between 9/30/11, the results in A1 is Y. If the date is 10/1/11 or later, the results are N.

Here is the formula that I received last night which works great except for the last part of the problem...

=IF(AND(DATE(2010,9,29)<=A1,A1<=DATE(2011,10,1)),"Y","N")

Thanks in advance for any help

N Before 9/28/10
Y Between 9/29/10 and 9/30/11
N After 10/1/11

[6StringJazzer]

I don't see where there is a problem. See attached file. All test cases work correctly. If it is not working for you then please attach your file.