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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]18/1/2006[/TD]
[TD]17/1/2006[/TD]
[TD]14/2/2006[/TD]
[/TR]
[TR]
[TD]19/1/2006[/TD]
[TD]14/2/2006[/TD]
[TD]14/2/2006[/TD]
[/TR]
[TR]
[TD]10/2/2006[/TD]
[TD]14/3/2006[/TD]
[TD]14/2/2006[/TD]
[/TR]
[TR]
[TD]13/2/2006[/TD]
[TD]18/4/2006[/TD]
[TD]14/2/2006[/TD]
[/TR]
[TR]
[TD]14/2/2006[/TD]
[TD]16/5/2006[/TD]
[TD]14/3/2006[/TD]
[/TR]
[TR]
[TD]15/2/2006[/TD]
[TD]20/6/2006[/TD]
[TD]14/3/2006[/TD]
[/TR]
[TR]
[TD]13/3/2006[/TD]
[TD]18/7/2006[/TD]
[TD]14/3/2006[/TD]
[/TR]
[TR]
[TD]14/3/2006[/TD]
[TD]15/8/2006[/TD]
[TD]18/4/2006[/TD]
[/TR]
[TR]
[TD]15/3/2006[/TD]
[TD]19/9/2006[/TD]
[TD]18/4/2006[/TD]
[/TR]
</tbody>[/TABLE]
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!