ppleasebob
Board Regular
- Joined
- Dec 23, 2002
- Messages
- 145
=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.
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.