View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Farmer Ted Farmer Ted is offline
external usenet poster
 
Posts: 12
Default Greater than and less than

I want to create a formula that will show that an Date in Column B is between
91 and 61 days old (From today) that a yes or no will display

My Formula (which does not work) is
=IF((TODAY()-D2) (<91AND 61),"Yes","No")

The Formual =IF ((Today()-d2) <61, "Yes","No") works.....but how do I create
a formual if both are true that it will display a YES OR if Not it will
display a NO