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
<colgroup><col span="2"><col><col><col><col></colgroup><tbody>
NAME
HIRE DATE
DOB
BILLY
9/27/1984
10/9/1960
TONY
10/3/1987
7/1/1962
WILLIAM
8/5/1989...