Hi. I have a column (A) with dates sorted by oldest to nearest. I also have another column (B) with dates but with gaps of 4 or 5 weeks between them. I would like to have a formula on another column that will bring me the first date in column B if that date is prior to column A.
An example so you can understand.
<tbody>
</tbody>Column C is my goal. C1 is 14/2/2006 because A1 is after B1. So he looks at B2 which is after A1 so it's good. C2 the same logic. C5 is 14/3/2006 because A5 is 14/2/2006 which is not prior to 14/2/2006 (When it's the same date I would like the next date). etc.
Hope you understand what I'm trying to do!
Thanks for any help!
An example so you can understand.
A | B | C |
18/1/2006 | 17/1/2006 | 14/2/2006 |
19/1/2006 | 14/2/2006 | 14/2/2006 |
10/2/2006 | 14/3/2006 | 14/2/2006 |
13/2/2006 | 18/4/2006 | 14/2/2006 |
14/2/2006 | 16/5/2006 | 14/3/2006 |
15/2/2006 | 20/6/2006 | 14/3/2006 |
13/3/2006 | 18/7/2006 | 14/3/2006 |
14/3/2006 | 15/8/2006 | 18/4/2006 |
15/3/2006 | 19/9/2006 | 18/4/2006 |
<tbody>
</tbody>
Hope you understand what I'm trying to do!
Thanks for any help!