View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
 
Posts: 690
Default today function in an "if" formula

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?



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

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

- -
HTH
Dana DeLouis