Brilliant! all formuals worked a treat and I thank you Ron and Bob for your
assistance and quick response
Regrads/sgl

"sgl" wrote:

> I have the followinig three columns
>
> Index DateFrom DateTo
> 1 28 Apr 04 28 Sep 04
> 2 28 Sep 04 28 Jan 05
> 3 28 Sep 04 29 Mar 05
> 4 29 Mar 05 28 Jul 05
> 5 28 Jul 05 30 Jun 06
>
> I want to obtain the MAX date in the DateTo column that is nearest to 1 Jan
> 05 which value resides in cell A1. This value is the result of another
> INDEX/MATCH formula. I have used the following formula (array Ctrl+Shift)
> obtained from this Discussion Group
>
> ={MAX(IF(DateTo<=A1,Index,0))}
>
> The result I get is 28 Sep 04 Index 1, whereas I want 28 Jan 05 with Index 2.
>
> Many thanks to you all
> Regards/sgl
>
>
>
>