if statement
 

i want to know the syntax for an if statement

i want the if statment to generate a "1", if the dates fall within the range
07/01/2002 - 06/30/2003 , if not, then "0"

thanks

if statement
 

Matt,

=IF(AND(A1=DATEVALUE("07/01/2002"),A1<=DATEVALUE("06/30/2003")),1,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"matt wolfe chazin" wrote in message
...
i want to know the syntax for an if statement

i want the if statment to generate a "1", if the dates fall within the
range
07/01/2002 - 06/30/2003 , if not, then "0"

thanks

if statement
 

Matt

=IF(AND(C1=A1,C1<=B1),1,0)

where :
A1 is 07/01/2002
B1 is 06/30/2003
C1 is the date to be checked

Regards

Trevor



"matt wolfe chazin" wrote in message
...
i want to know the syntax for an if statement

i want the if statment to generate a "1", if the dates fall within the
range
07/01/2002 - 06/30/2003 , if not, then "0"

thanks