You're welcome - thanks for feeding back.

Pete

On Nov 13, 4:28*pm, RainyDay
wrote:
Thank you everyone, that was a big help!



"Pete_UK" wrote:
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

On Nov 13, 4:10 pm, RainyDay
wrote:
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?- Hide quoted text -

- Show quoted text -