if we are given birth date (eg 12-june-1993), we need to calculate the average age as at 1 jan 2013. (note: if there are like 100 records of different birth dates, how to calculate the 100 records in the shortest possible method?)
I know of one way.. that is to select the column which I place 1 jan 2013 MINUS the birth date and DIVIDE by 365.25... but if there are like 100 records.. I cant possibly use this method one by one right??? is there a short cut??


another question.. if to calculate the average length of service an employee has been working in a company.. the joined date is given in this format (eg 2-sep-1990) and there are like 100 records of different employees.. how to calculate??? note: in the computation allowed to use 30days = 1 month

i'm not proficient in Microsoft excel.. so im trying to find out... thanks.