View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Totti Totti is offline
external usenet poster
 
Posts: 51
Default 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.