|
i think i got it.
i made a dummy one, that is very simple. i can email it to you.
basically
name, hired date, dob, seniority, age.
then i had a cell floating on the side with todays date. subtract hired date from todays date, and do the same for age. those cells you have to format to a number and round it to the nearest whole number. that number will be in days. divide by 365 to get years if you want. then use the data button on the toolbar, and sort by decending order, choose the seniority column as your criteria. it will flip everyone from newest hire to oldest hire. and the age will not be affected.
__________________
poof! gone
|