[rattlsnak]

basically what i am trying to do is determine where "you" will be 1,5,10 etc,. years from now on a seniority list. I have a listing of @2,000 people with seniority dates and birthday dates. I need a function that will figure that out. i.e.- an employee who is number 500 on the list wants to know what his seniority number will be in five years. I have seniority numbers, names, and birthdays (using 60 as a retirement age for this project) all in seperate columns. So the function will have to determine where "he" is on the list, and then determine how many people above on the list will retire in the number of years he plugs in, and then give him a new seniorty number.. ?

I also have Access, if it can be done easier on that, but would rather Excel.