| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date lies between
I have 2 date column in sheet "DB" and I need to find if the date entered in
sheet1 lies between these dates.. That is for Example - if I enter dates 12-May to 15-May it should say "True" or what ever else "false" Its should check the entire column and give the result. From To 12-May 15-May 25-May 26-May 28-May 01-Jun 05-Jun 08-Jun |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date lies between
'If there is only 1 query date then try the below with query date in cell E1
=SUMPRODUCT((DB!A1:A5<=E1)*(DB!B1:B5=E2))<0 If it is a date range; then try the below with E1 and E2 as start/end dates.. =SUMPRODUCT((DB!A1:A5<=E1)*(DB!B1:B5=E2))<0 "Kash" wrote: I have 2 date column in sheet "DB" and I need to find if the date entered in sheet1 lies between these dates.. That is for Example - if I enter dates 12-May to 15-May it should say "True" or what ever else "false" Its should check the entire column and give the result. From To 12-May 15-May 25-May 26-May 28-May 01-Jun 05-Jun 08-Jun |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Heiarchy and Highlight rows where certain data lies | Excel Programming | |||
| Adding Data That Lies Between Two Dates | Excel Discussion (Misc queries) | |||
| Finding the cell in which an object lies | Charts and Charting in Excel | |||
| Change top line data and remove lower lies | Excel Programming | |||
| Cell lies within range | Excel Programming | |||
Hybrid Mode
