formula to caluclate the # of years and months between two dates
 

Look at the DATEDIF function. it will look something like this

=DATEDIF(A1,A2,"Y")
results in whole years between two dates.

=DATEDIF(A1,A2,"YM")
results in whole months between two dates (ignores years)

for example...
A1=6/11/2005
A2=11/30/2006
A3=DATEDIF(A1,A2,"Y") - 1
A4=DATEDIF(A1,A2,"YM") - 5
A5=DATEDIF(A1,A2,"Y")&" years, and "&DATEDIF(A1,A2,"YM")&" months." - 1
years, and 5 months.

"Christyepd" wrote:

I am setting up the employees lenths of service from the date hired until
present date.