Bring the first date prior to a date

[phil133]

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.

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>

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!

 

[FormR]

Hi, is this it maybe?

Excel 2013/2016
	A	B	C
1	A	B	C
2	18/01/2006	17/01/2006	14/02/2006
3	19/01/2006	14/02/2006	14/02/2006
4	10/02/2006	14/03/2006	14/02/2006
5	13/02/2006	18/04/2006	14/02/2006
6	14/02/2006	16/05/2006	14/03/2006
7	15/02/2006	20/06/2006	14/03/2006
8	13/03/2006	18/07/2006	14/03/2006
9	14/03/2006	15/08/2006	18/04/2006
10	15/03/2006	19/09/2006	18/04/2006
Sheet1

Cell Formulas
Range	Formula
C2	=INDEX($B$2:$B$10,MATCH(TRUE,INDEX($B$2:$B$10>A2,0),0))

 

[phil133]

Thank you FormR! This works great!