try
=if(a3-a2)=30,1,"not one")

--
Don Guillett
SalesAid Software

"metaltecks" wrote in message
...
I have 2 columns, ADM and DISC. These are both date fields in the format of
6/20/2006.

In a column next to these 2 columns, I want to create a formula that will
check the difference between the 2 dates. If the date difference reaches
30
days, I would like for it to place a 1 in there, otherwise, nothing. I've
had
problems trying to create the if statement, but have had no sucess in
doing
it...can someone help me.

Thank you