HELP NEEDED: Date Range in Excel

[swoo]

Could someone please help me out with the following scenario:

I have a column which contains various dates. What I want to be abl
to do look at one cell and perform an IF function. IF the cell's dat
is between this date and that date THEN do this (mathematica
expression).

Does anyone know how to do this or can anyone suggest a better method

 

[Frank Kabel]

Hi
try something like
=IF(AND(A1>=DATE(2004,4,9),A1<=DATE(2004,4,13)),1,0)