seniority

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...

I am creating a pricing template for services, a section of which is based on an hourly rate. The rates, are by level of seniority which need to be added together then multiple by the number of hours. I would like the option of only selecting the level of seniority and adding the hours, then...

Hello all Help needed with updating table data with dynamic range. i have two sheets. Sheet1 has data with four columns A. Seniority No B. Rank C. DOB D. DOR (Retirement) - Seniority is sequential 1 - 3000 - Ranks are say A to G - DOR - incase of retirement if rank is A or B or C then DOB + 60...

Hi There This is probably a very simple thing, but I am no excel expert and am wondering if someone could suggest a formula. I have an employee schedule. Some employees have set rotations of shifts and others do not. I have assigned them all a number to start with based on the lines that they...