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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date lies between
You havent mentioned any thing about the names in your initial post...and so
its not clear to me.. "Kash" wrote: This works.. but the thing is column changes with the value in F5 on Sheet1 if value is XYZ the it will be column a,b if value is MNO the it will be column c,d and so on.. have allotted 2 columns per name.. can we do this using formula or I need a macro? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date lies between
I agree I had not mentioned.. but any solution now?
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date lies between
Still it is unclear..Elaborate how your data is arranged so that someone here
could help. "Kash" wrote: I agree I had not mentioned.. but any solution now? |
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 |