Date in formula

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
Sun May 11 08:42:45 CDT 2008

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"alish" <alish@discussions.microsoft.com> wrote in message
news:F3A8825F-7569-46BF-B9A1-4D1B66BBA33B@microsoft.com...
> 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.
>

Bob
Sun May 11 08:52:59 CDT 2008

=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" <alish@discussions.microsoft.com> wrote in message
news:F3A8825F-7569-46BF-B9A1-4D1B66BBA33B@microsoft.com...
> 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
Sun May 11 09:53:54 CDT 2008

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"Bob Phillips" <bob.ngs@somewhere.com> wrote in message
news:Ox5EM52sIHA.5096@TK2MSFTNGP02.phx.gbl...
> =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" <alish@discussions.microsoft.com> wrote in message
> news:F3A8825F-7569-46BF-B9A1-4D1B66BBA33B@microsoft.com...
>> 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.
>>
>
>

Bob
Sun May 11 10:15:21 CDT 2008

Thank-you.

--
HTH

Bob

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

"Don Guillett" <dguillett1@austin.rr.com> wrote in message
news:exyuYb3sIHA.5096@TK2MSFTNGP02.phx.gbl...
> typos
> =IF(A2<--"2008-04-01","old","ok")
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguillett1@austin.rr.com
> "Bob Phillips" <bob.ngs@somewhere.com> wrote in message
> news:Ox5EM52sIHA.5096@TK2MSFTNGP02.phx.gbl...
>> =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" <alish@discussions.microsoft.com> wrote in message
>> news:F3A8825F-7569-46BF-B9A1-4D1B66BBA33B@microsoft.com...
>>> 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.
>>>
>>
>>
>

Rick
Sun May 11 10:35:08 CDT 2008

Here is one more way...

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

Rick


"alish" <alish@discussions.microsoft.com> wrote in message
news:F3A8825F-7569-46BF-B9A1-4D1B66BBA33B@microsoft.com...
> 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.
>