Find Date Between?
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 ideas, anyone?
|