ExcelBanter - Using IF and date ranges

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using IF and date ranges (https://www.excelbanter.com/excel-worksheet-functions/196214-using-if-date-ranges.html)

Romanli

Using IF and date ranges

I am trying to find information that meets the following criteria:

If n2is between 07/01/2008 and 07/23/2008 and 02 is between 08/01/2008 and
08/31/2008 then the answer is yes

I really want to highlight the row with this information, but a simple yes
or no in a new column would be fine.

Bob Phillips[_3_]

Using IF and date ranges

=IF(AND(N2=--"2008-07-01",N2<=--"2008-01-23,O2=--"2008-08-01",O2<=--"2008-08-31"),"Yes,"No")

--
__________________________________
HTH

Bob

"Romanli" wrote in message
...
I am trying to find information that meets the following criteria:

If n2is between 07/01/2008 and 07/23/2008 and 02 is between 08/01/2008 and
08/31/2008 then the answer is yes

I really want to highlight the row with this information, but a simple yes
or no in a new column would be fine.

All times are GMT +1. The time now is 06:06 AM.