Formula to pull Min & Max Date

[klynn]

I am looking for a formula that will look at the value in the WeekA column and bring back the min SD and the max FD. The Min Start column is the value I should get for all cells in WeekA with 17.

SD FD WeekA Min Start Max Finished
03/31/03 04/22/03 17 3/31/2003 4/23/2003
04/02/02 04/23/03 17 3/31/2003 4/23/2003
10/15/02 11/15/02 46
10/16/02 11/14/02 46

Any help would be greatly appreciated. Thanks

 

[Mark W.]

If I understand your requirements your posted results are incorrect (2002<2003)...

Book1
	A	B	C	D	E	F	G	H	I	J
1	SD	FD	WeekA	MinStart	MaxFinished
2	3/31/2003	4/22/2003	17	4/2/2002	4/23/2003
3	4/2/2002	4/23/2003	17	4/2/2002	4/23/2003
4	10/15/2002	11/15/2002	46	10/15/2002	11/15/2002
5	10/16/2002	11/14/2002	46	10/15/2002	11/15/2002
6
7
8
9
Sheet1

 

[klynn]

I apologize, it was a typo. My problem has been solved, thank you very much.