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

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?

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

one way:

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

Regards

Trevor


"Dustin" wrote in message
...
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?

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

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


--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Trevor Shuttleworth" wrote:

one way:

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

Regards

Trevor


"Dustin" wrote in message
...
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?

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

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

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

"Martin Fishlock" wrote:

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


--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Trevor Shuttleworth" wrote:

one way:

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

Regards

Trevor


"Dustin" wrote in message
...
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?