Thread: How to find if a date falls between 2 dates
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default How to find if a date falls between 2 dates
=AND((A1=--"2005-01-01")),(A1<--"2005-02-01)"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JHL" wrote in message
...
I've tried =if(and(cell= "1-1-2005",cell<"2/01/2005"),"yes", "no") and
the
result is not right. Any thoughts?


Reply With QuoteReply With Quote