Need true or false if a date falls between a date range

[Guest]

Hi there,

Simply put, I'm looking for this

IF(CELL VALUE is between January 1, 2006 and January 31, 2006, True, False)

Any ideas?

 

[Trevor Shuttleworth]

one way:

=IF(AND(C1>=DATE(2006,1,1),C1<=DATE(2006,1,31)), TRUE,FALSE)

Regards

Trevor

 

[Guest]

Just to point out that you don't really need the if statement and it will
work with just the logic ans you want a boolean answer:

=AND(C2>=DATE(2006,1,1),C2<=DATE(2006,1,31))

 

[Guest]

If your range is always a whole month you could also use

=TEXT(A1,"mmm yy")="Jan 06"