today function in an "if" formula

  • Thread starter Thread starter RainyDay
  • Start date Start date
R

RainyDay

I tried to make a formula that would return a 1 only if today is past a
certain date. I tried
=IF(TODAY()>11/14/2008,1,0)
but it returns a 1 irregardless of what date I put in the formula. Where did
I go wrong?
 
RainyDay said:
I tried to make a formula that would return a 1 only if today is past a
certain date. I tried
=IF(TODAY()>11/14/2008,1,0)
but it returns a 1 irregardless of what date I put in the formula. Where did
I go wrong?
Click to expand...


=IF(TODAY()>DATE(2008,11,14),1,0)
 
The Date needs to be in quotes, and ensure the date isn't "ambiguous".
=IF(TODAY()>"11/14/2008",1,0)
Or you could put the date in cell A1 and
=IF(TODAY()>A1,1,0)
 
If you want to keep that date in a recognisable format, try it this
way:

IF(TODAY()>--"11/14/2008",1,0)

Hope this helps.

Pete
 
Thank you everyone, that was a big help!

Pete_UK said:
If you want to keep that date in a recognisable format, try it this
way:

IF(TODAY()>--"11/14/2008",1,0)

Hope this helps.

Pete
Click to expand...
 
RainyDay said:
I tried to make a formula that would return a 1 only if today is past a
certain date. I tried
=IF(TODAY()>11/14/2008,1,0)
but it returns a 1 irregardless of what date I put in the formula. Where did
I go wrong?
Click to expand...


If it's just 1/0, just another way...

=--(TODAY()>DATE(2008,11,14))

- -
HTH
Dana DeLouis
 

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

Help needed with If & Today function 4
Monday closest to today's date? 6
Workday Formula to include date 0
Today() and IF Function 6
Searching the formula (not the value) for a text string 1
TODAY() function problem 3
Formula to return date of following Friday 5
Date functions 2

Back
Top