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)
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


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