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

Greater than and less than
 

Try
=IF(AND(TODAY()-D2<91, TODAY()-D261)),"Yes","No")

"Farmer Ted" wrote:
=IF((TODAY()-D2) (<91AND 61),"Yes","No")

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

Greater than and less than
 

=IF((TODAY()-D2) (<91AND 61),"Yes","No")

I'm not too good with date formulas but see if this does what you want...

=IF(AND(TODAY()-D261,TODAY()-D2<91),"Yes","No")

--
Biff
Microsoft Excel MVP


"Farmer Ted" wrote in message
...
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

Greater than and less than
 

Sorry that did not work. any othr help?

"Sheeloo" wrote:

Try
=IF(AND(TODAY()-D2<91, TODAY()-D261)),"Yes","No")

"Farmer Ted" wrote:
=IF((TODAY()-D2) (<91AND 61),"Yes","No")

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

Greater than and less than
 

This worked:

=IF(AND(TODAY()-D2<91, TODAY()-D261),"Yes","No")

"Sheeloo" wrote:

Try
=IF(AND(TODAY()-D2<91, TODAY()-D261)),"Yes","No")

"Farmer Ted" wrote:
=IF((TODAY()-D2) (<91AND 61),"Yes","No")

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