Lookup first date in a range after visit date

[triboji]

Can someone help me figure out the formula for column 5 that will identify the earlier date in date columns 2-4 that occurs after the date in column 1? Thus, for the first row it would give 1/15/13, but for the second row would give 3/1/13.

visit date1	date 2	date3	date4	Col5
1/1/13	1/15/13	3/1/15	2/1/15
2/1/13	1/15/13	1/31/13	3/1/13

<tbody>
</tbody>

 

[Weazel]

maybe something like...


=MIN(IF(B2:D2>A2,B2:D2))

which is an array and needs to be entered with Control + Shift + Enter.

 

[Special-K99]

=MIN(IF(B1:D1>A1,B1:D1,""))
Note Array formula, use Ctrl-Alt-Enter

Then copy down

 

[triboji]

Perfect - thanks