Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Check if a date comes before/after a range of dates
Hi all,
If I have two sheets both with a column of dates included... Is it possible to look up a date in say, 'Sheet B' against the whole column of dates in 'Sheet A' and return a simple yes/no if the date in 'Sheet B' comes before any other date in the 'Sheet A' column of dates? i.e... 'SHEET A' A B 1 18/01/2012 2 14/05/2010 3 12/10/2011 4 22/03/2012 5 04/02/2009 'SHEET B' A B 1 16/11/2012 No 2 07/12/2010 No 3 26/01/2008 Yes 4 09/08/2012 No 5 30/06/2008 Yes B3 & B5 will then say 'Yes' as both of dates in cells A3 & A5 are before any date in the whole column of 'Sheet A.' Hope that makes sense. Thank you in advance, Jay |
#2
|
|||
|
|||
Quote:
|
#3
|
|||
|
|||
Is this what you mean?
Not done with a VLOOKUP but rather an array IF formula. |
#4
|
|||
|
|||
Brilliant! Thanks Spencer. Works like a good'un.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check dates against a date range. | Excel Discussion (Misc queries) | |||
Check if date is between two dates, then sum only those rows | Excel Worksheet Functions | |||
Dates: How to check if date value is 10 months and or 1 year old? | Excel Programming | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Check column of dates against todays date | Excel Worksheet Functions |