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.
|