View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Romanli Romanli is offline
external usenet poster
 
Posts: 5
Default 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.