Hello once again,
I've just found the solution:

(Array entered)
=MIN(IF(B:B>=D1;A:A))


"markx" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I have two columns: "Starting date" (A) and "Ending date" (B) with values
> in more than 100 rows.
> In addition, I have current date in D1 cell.
>
> I want to run on the A column a conditional MIN() function and do the
> following:
> Find MIN in column A, but excluding (from the calculation) the rows where
> the value in B column (ending date) is smaller than the current date
> (specified in D1 cell).
>
>
> If D1 = 01 May 2006
> and the rows are:
> column A column B
> 1 Jan 02 1 Dec 2005
> 1 Mar 03 1 Jan 2006
> 1 Dec 03 1 Mar 2008
> 1 Apr 05 1 Aug 2007
> then the normal MIN(A:A) would give me 1 Jan 02
>
> However, I'm looking for 1 Dec 03 (=the smallest value in column A among
> the rows where the value in column B is equal or bigger than D1).
>
> Could you give me some hints how to achieve this?
> Many thanks for your help!
>
> Mark
>