today function in an "if" formula

[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?

 

[Glenn]

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?

=IF(TODAY()>DATE(2008,11,14),1,0)

 

[John C]

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)

 

[Alan Moseley]

try =IF(TODAY()>DATE(2008,11,14),1,0)

 

[Pete_UK]

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

 

[RainyDay]

Thank you everyone, that was a big help!

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

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Thank you everyone, that was a big help!





- Show quoted text -

 

[David Biddulph]

Where you went wrong is that you compared not with a date but with a small
number (11 divided by 14, and then that result divided by 2008).
Others have suggested ways of getting it right.

 

[Dana DeLouis]

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?

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

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

- -
HTH
Dana DeLouis