Thread
:
Date in formula
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett