Identifiy a date within a range

[david_excel]

I have a worksheet with two colums with a from and to date. There are approx 1000 lines.

I need to identiy a specific date between the two dates. e.g From date = 1/12/2004 to date = 12/6/2005.

I need to idenfiy if a date is within the range eg. 01/06/2005. All I need is a true - false answer.

Thanks

[JeanRage]

Hi,

See attached sample file ...

HTH

[DonkeyOte]

I'd just add to JR's post/attachment that if as you say you really only need a Logical returned then you can dispense with the IF and just use the AND, ie:

=AND($E$1>A2,$E$1<B2)