Grab data if date conditions are met...

I am looking at cycles starting from K1 all the way to B1.
For each date in column A I want to find the data point corresponding to the right cycle for "date + 10 days" (which I have in column M).
Column P have the results I need. For example I get P2 by looking at M2 and STARTING AT K1, I want to find the date > M2 AND closest to M2. So my loop will start at K1, then J1 then I1 and so on until it fulfills the condition and then will return the data underneath.
I would like my macro to take into account column M so it does not appear on the sheet.

Thanks!!!!

thanks guys!

Hey Ben, do you know how to do "greater than OR EQUAL" with the match function? (-1 does greater than).

Yes, the data must arranged in order first though.

PCI, it works great but I was trying to get a code without the use of a function and also with dynamic ranges as my data and ranges will change everyday as I add more data. Sorry for not detailing more at first.

PCI, by dynamic range I mean that there will be more data added and therefore the range b1:k1 will grow, as well as the full array of data. And a macro that prints the results in a certain column would be better than a function. thanks!!

Thanks PCI its great! why do you set RRg as range and not date?