| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If and Date Ranges | Excel Worksheet Functions | |||
| date ranges | Excel Worksheet Functions | |||
| compare date to various date ranges and sum value | Excel Worksheet Functions | |||
| If then Date Ranges | Excel Worksheet Functions | |||
| sum of date ranges | Excel Worksheet Functions | |||
Hybrid Mode
