Calculating Dates in Excel XP

[Barbara265]

Hello,

I need to calculate the length of service based on date of hire (in years, months, days) for each employee within a group, and then calculate the average length of service (in years, months, days) for the entire group.

Any suggestions will be gratefully accepted!

Barb

 

[Dreamboat]

Dates and times by the Pearson man:

http://www.cpearson.com/excel/datetime.htm

Make sure you get to see the whole page and its links. Anne Troy

http://www.TheWordExpert.com

http://www.Brainbench.com

 

[ETID]

if the hire date is in col a then for the employee in row 2 the formula would be....

in col b
Years:
=datedif(a2,now(),"Y&quot
in col c
Months:
=datedif(a2,now(),"M&quot
in col d
Days:
=datedif(a2,now(),"D&quot


then run an average on each col.

 

[Barbara265]

Thank-you both for the suggestions.

Barb

 

[xlbo]

ETID - I don't think tthat'll work - surely you get the same time period but expressed in different formats eg 2 years would be
2
24
730

May I suggest you make life easier for yourself and do the whole thing in days

=TODAY()-DateOfHire
format as number and away you go Rgds
~Geoff~