Thread: Date in formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Date in formula

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.