Thank-you.

--
HTH

Bob

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

"Don Guillett" wrote in message
...
typos
=IF(A2<--"2008-04-01","old","ok")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
...
=If(A2<--"2008-04-012,"old","ok")


--
HTH

Bob

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

"alish" wrote in message
...
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.