Using IF and date ranges

R

Romanli

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.
 
B

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If and Date Ranges 1
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Conditional sum equals 0 4
IF statement with 2 logicals 1
Find then highlight in yellow 6
Sum value between two dates and copy to new cell 7
IF FUNCTION? 6
Date Function 2

Top