View Single Post
vash vash is online now
Registered
 
vash's Avatar
 
Join Date: Sep 2003
Location: in my mind.
Posts: 32,283
Garage
Send a message via AIM to vash
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
Old 03-14-2006, 02:37 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #13 (permalink)