BBlu
asked on
Way to find first date that occurs after another date in a column
I have a column with dates in it. I'd like to find the earliest date that occurs after 12/31/08. In other words, if I have:
1/4/08
2/23/08
4/3/08
12/30/08
4/1/09
5/8/09
11/25/09
1/1/10
5/6/10
12/4/10
1/23/11
I'd like it to return: 4/1/09
1/4/08
2/23/08
4/3/08
12/30/08
4/1/09
5/8/09
11/25/09
1/1/10
5/6/10
12/4/10
1/23/11
I'd like it to return: 4/1/09
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Attched working example...
MinDate.xlsx
MinDate.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you all. I was working along the lines of the min() function with an array formula, but failed to think of the if statement part. I also like the vlookup suggestion because it allows for finding the nth date. Thank you all. As usual, you guys are amazing.
ASKER
Thank you all!
if B1 =12/31/08
B2 =VLOOKUP(B1, $A$1:$A$100, 1)