Thread: today function in an "if" formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Moseley Alan Moseley is offline
external usenet poster
  
Posts: 75
Default today function in an "if" formula
try =IF(TODAY()DATE(2008,11,14),1,0)
--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"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?
Reply With QuoteReply With Quote