Date in formula

  • Thread starter Thread starter alish
  • Start date Start date
A

alish

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.
 
=If(A2<--"2008-04-012,"old","ok")


--
HTH

Bob

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Here is one more way...

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

Rick
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help with a date formula. 3
FORMULA NEEDED FOR MONTHS 1
Earlest Date Based On A Date Using Min Formula 5
Merge two cells with dates to create a date range 7
Seniority Years Formula needed 5
Insert date in formula 2
Return a value when Date x is between Date y and z 4
Comparing Dates in 4 Columns - Nested Formulas? 2

Back
Top