Thread: Date in formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_426_] Rick Rothstein \(MVP - VB\)[_426_] is offline
external usenet poster
 
Posts: 1
Default Date in formula

Here is one more way...

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

Rick


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