calculate years of service
 

Does anyone know how to calculate years of service in Excel? (ex. 3 years, 4
months)

calculate years of service
 

Look he

http://www.cpearson.com/excel/datedif.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JenniferD" wrote in message
...
Does anyone know how to calculate years of service in Excel? (ex. 3 years,
4
months)

calculate years of service
 

Hi
Try this with your starting date in cell A2, You can remove the day section if
you don't want it.
DATEDIF(A2,TODAY(),"y")&" Years, "&DATEDIF(A2,TODAY(),"ym")&" Months and
"&DATEDIF(A2,TODAY(),"md")&" Days"
HTH
John
"JenniferD" wrote in message
...
Does anyone know how to calculate years of service in Excel? (ex. 3 years, 4
months)