Date in formula

[alish]

Hi All,
I need your help in showing me how to put a date in the formula, for
instance:
=If(A2<4/01/2008,"old","ok")
I know I can't just put a date there, I think there must be something at
each ends of the date.
Thanks.

 

[Don Guillett]

try
=IF(A2<DATEVALUE("4/1/2008"),"old","ok")

 

[Bob Phillips]

=If(A2<--"2008-04-012,"old","ok")


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Don Guillett]

typos
=IF(A2<--"2008-04-01","old","ok")

 

[Bob Phillips]

Thank-you.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Rick Rothstein \(MVP - VB\)]

Here is one more way...

=IF(A2<DATE(2008,4,1),"old","ok")

Rick