find 2nd occurence
I forgot to say that in K:K i have the starting date of the interval
=left(A2,10) and in J:J i have the end dates = right(A2,10)
and it works fine so if the date start date * date < end date, this
will give me "1" in the truth table and i am matching the 1, and
getting the code.
|