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

D

Dustin

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?
 
T

Trevor Shuttleworth

one way:

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

Regards

Trevor
 
M

Martin Fishlock

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))
 
D

daddylonglegs

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

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