calculate years of service

J

JenniferD

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

John

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation using a date 6
FV when compounding occurs every 30 months 2
I need help on SQL 0
Add/Sum up months, years, dates 4
Calculating Future Value 6
Excel - Calculate age from DOB in years, months days 7
if statements 3
Contract Value Formula 0

Top