Need help to identify if a specific date falls within a date range

[Lee Jeffery]

Hello,

Using Excel 97 on WINNT.

Column C contains a start date (for example 20/12/2004 ) and column
an end date (for example 31/12/2004) for about 3000 entries.

Is there a formula or function I can apply to identify if the dat
30/12/2004 falls within this range, please? I have looked at Chi
Pearson's and David McRitchie's sites but am unable to see anythin
which applies to this problem (or maybe I'm just thick ... hmmm ..
could be something in that).

Any assistance would be greatly appreciated.

TIA.

Lee Jeffery :

 

[Biff]

Hi!

B1 = 30/12/2004

Try one of these formulas:

=AND(B1>=C1,B1<=D1) TRUE or FALSE

=IF(AND(B1>=C1,B1<=D1),"Yes","No") Yes or No

Biff