So the employees with the oldest date would be ranked 1? If seniority dates are in B2:B100 then try this formula in A2 copied down

=RANK(B2,B$2:B$100,1)