Hello experts.  I have an array of dates, like this:
08/07/2013
02/07/2014
08/07/2014
02/07/2015
08/07/2015
02/07/2016
08/07/2016
02/07/2017
08/07/2017

I know a transaction will happen on this date:
6/15/2015


I want to find the NEXT date after that transaction date.  So, I want to find this date:
08/07/2015

Basically, 6/15/2015 is greater than 02/07/2015.

I tried Offset and Indirect.  I can't seem to get this to work.  As you can assume, I can't just do a simple comparison like this:
=IF(AND(A2>$B$1,A2<$c$1),a2, FALSE)

It needs to be a little more intelligent than that.

Any idea

Let's say that the dates are in A2:A10, and the transaction date is in B2. The first date in the range A2:A10 on or after the transaction date in B2 is given by the array formula (confirmed with Ctrl+Shift+Enter)

=MIN(IF(B2<=$A$2:A$10,A$2:A$10,DATE(9999,12,31))

Format the cell with the formula as a date.

If you want the first date after the date in B2, change <= to < in the formula.

Remark: if all dates in A2:A10 are before the transaction date, the formula will return 12/31/9999.

Thanks a lot!!  Just one thing.  This doesn't seem to work on cells referenced to other cells.  It looks like I need to copy > paste special values and then convert everything to a date.  Is that right?

Oh, I got it.  I need to format all the cells like this:

=--TEXT(D33,"MM/DD/YYYY")

Jeezzzz!!  Who comes up with this stuff!!??

That suggests that there were text values that looked like dates among your data.