Im trying to get excel to rank the employees in seniority based on hire date and if hire date then rake them based on the oldest
[TABLE="width: 681"]
<colgroup><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD]
NAME[/TD]
[TD]
HIRE DATE[/TD]
[TD]
DOB[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BILLY[/TD]
[TD]9/27/1984[/TD]
[TD]10/9/1960[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TONY[/TD]
[TD]10/3/1987[/TD]
[TD]7/1/1962[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WILLIAM[/TD]
[TD]8/5/1989[/TD]
[TD]7/6/1967[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TIM[/TD]
[TD]3/14/1990[/TD]
[TD]9/20/1968[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JACK[/TD]
[TD]1/10/1993[/TD]
[TD]3/20/1968[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RANDY[/TD]
[TD]1/10/1993[/TD]
[TD]5/28/1968[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BRANDON[/TD]
[TD]1/10/1993[/TD]
[TD]8/23/1975[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
in column D
which does fine until i get to JACK, RANDY, and Brandon and all are raked number 5. I need a tie breaker based on the oldest. of the 3
any suggestion on what to add to Column D formula to check the DOB if employee hired on the same day or any other way to go about doing this
Thanks
[TABLE="width: 681"]
<colgroup><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD]
NAME[/TD]
[TD]
HIRE DATE[/TD]
[TD]
DOB[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BILLY[/TD]
[TD]9/27/1984[/TD]
[TD]10/9/1960[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TONY[/TD]
[TD]10/3/1987[/TD]
[TD]7/1/1962[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WILLIAM[/TD]
[TD]8/5/1989[/TD]
[TD]7/6/1967[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TIM[/TD]
[TD]3/14/1990[/TD]
[TD]9/20/1968[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JACK[/TD]
[TD]1/10/1993[/TD]
[TD]3/20/1968[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RANDY[/TD]
[TD]1/10/1993[/TD]
[TD]5/28/1968[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BRANDON[/TD]
[TD]1/10/1993[/TD]
[TD]8/23/1975[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
in column D
Code:
=RANK(b2,$b$2:$b$8)
which does fine until i get to JACK, RANDY, and Brandon and all are raked number 5. I need a tie breaker based on the oldest. of the 3
any suggestion on what to add to Column D formula to check the DOB if employee hired on the same day or any other way to go about doing this
Thanks