Why doesn't this work???

[ppleasebob]

=IF(B2>=I2,IF(B2<=M2,"Y"),"N")

B2 = 30/05/2010
I2 = 29/05/2010
M2 = 28/05/2011
(these are UK style dates)

I2 is the start date, M2 is the expiry date, B2 is a date that I want to confirm is between the start and the expiry dates.
Why should this formula give FALSE in the example above?, I would expect a Y in this instance..

Any suggestions gratefully received.

 

[kpark91]

Because you need another "N" for the inside IF statment

=IF(B2>=I2,IF(B2<=M2,"Y", "N"),"N")

 

[jmthompson]

I think your data may not be recognized as dates. It wasn't for me when I copied and pasted your information, even after I ensured the values were numbers by multiplying by 1.

When I manually keyed the dates in, it works (and yes, I did add a second False statement.

 

[ppleasebob]

thanks chaps,

 

[Ruddles]

Nested IFs are often tricky. Try:-

=IF(AND([COLOR=blue]B2>=I2[/COLOR],[COLOR=magenta]B2<=M2[/COLOR][COLOR=black]),"Y","N")[/COLOR]