If and Date Ranges

[Romanli]

How do I use the if function if I want to highlight the rows where certain
cells are within certain date ranges

If n2is between 07/01/208 and 07/23/2008 and b2 is between 08/01/0808 and
08/31/2008.

I will want to highlight the rows - but would settle for a simple yes or no.

 

[OssieMac]

Hi Romanli,

the following should give you a "Yes" or "No".

=IF(AND(N2>=DATEVALUE("7/1/2008"),N2<=DATEVALUE("7/23/2008"),B2>=DATEVALUE("8/1/2008"),B2<=DATEVALUE("8/31/2008")),"Yes","No")


Note that the above is all one line of formula.