View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default today function in an "if" formula

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.
--
David Biddulph

"RainyDay" wrote in message
...
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?