Bonsour® Randy avec ferveur ;o))) vous nous disiez :

Ok.. here's the problem.. I'm re-creating a seniority list for my
company.. I need a column to show an employee's 'seniority number'..
(ex, the employee thats been with our company the longest would be
assigned #1.. second longest #2.. etc..).. the problem is when
someone quits or retires I have to manually change all the seniority
numbers beneith them.. is there any way that Excel can do this
automatically for me.. for administrative purposes.. I can arrange
employees by hire date.. however our union wants each employees
seniority number listed

1 - for hiredate next column, put that formula
=RANK(CurHireDate, HireDatesRange,True)
2 - pull down as wanted

HTH