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