Finding Max/Min dates from a table

[ramon75]

Hello,

I hope someone can help me.
How can I get the max/min dates from a table based on a person's data.
For instance, I have the table as in the table below, where I am trying to get each person max and min date that they got paid.
In red on the right are values that I typed based on the table for Person 1.
But how to make a formula for this please?
Thank you in advance.

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Earnings	01-Jan-16	02-Jan-16	03-Jan-16	04-Jan-16	05-Jan-16	06-Jan-16	07-Jan-16	08-Jan-16	09-Jan-16	10-Jan-16	11-Jan-16	12-Jan-16	13-Jan-16	14-Jan-16	15-Jan-16		Minimum Date	Maximum Date
2	Peron 1	$500	$550	$578	$606	$637	$669	$702	$737	$774	$813	$853	$896					01-Jan-16	12-Jan-16
3	Peron 2		$300	$315	$331	$347	$365	$383	$402
4	Peron 3					$200	$210	$221	$232	$243	$255
5	Peron 4											$100	$100	$200
6	Peron 5							$500							$500
7	Peron 6	$300		$400			$600					$400
8	Peron 7		$200	$200	$200
9	Peron 8					$700
10	Peron 9		$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100
11	Peron 10	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150

<tbody>
</tbody><colgroup><col span="2"><col span="15"><col><col><col></colgroup>

 

[tygrrboi]

for Min

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #0057d6}span.s2 {color: #006107}span.s3 {color: #ab30d6}</style>=INDEX($B$1:$P$1, MATCH(AGGREGATE(5,3,$B2:$P2), $B2:$P2,0))

for Max

=INDEX($B$1:$P$1, MATCH(AGGREGATE(4,3,$B2:$P2), $B2:$P2,0))


(only will work with Excel 2010 or higher versions)

 

[Tetra201]

Cell R2 =MIN(IF($C2:$Q2 < > "",$C$1:$Q$1))
Cell S2 =MAX(IF($C2:$Q2 < > "",$C$1:$Q$1))
Both formulas should be entered with Ctrl+Shift+Enter

 

[igold]

Cell R2 =INDEX($B$1:$P$1,MATCH(MIN($B2:$P2),$B2:$P2,0))
Cell S2 =INDEX($B$1:$P$1,MATCH(MAX($B2:$P2),$B2:$P2,0))

Both formulas copied down.

igold

 

[RedBeard]

Never mind, see the above, hah.

 

[Maverick23]

How can I find the next minimum date from a table? I have a table of dates that are arranged out of sequence and many are the same date. I want to find the minimum date and in next cell, the next minimum date, and so on until all dates are arranged. I tried ranking the dates in ascending order but ranking skips numbers based on the number of same dates.