Use of dates in conditional and AND formulas

  • Thread starter Thread starter Pam D in Indy
  • Start date Start date
P

Pam D in Indy

I'm not getting good values when I use dates in conditional or AND formulas.
Example: =if(A1>1/1/2004),1,0)
Example: =IF(AND(A1>1/1/2004,A1<1/1/2007),1,0)

Everything comes back either true or false, but not true to case.
 
Try

=IF(A1>--"2004-01-01",1,0)

or


=IF(A1>DATE(2004,1,1),1,0)


change the date the same way for your AND formula

--


Regards,


Peo Sjoblom
 
Back
Top