calculate years of service

  • Thread starter Thread starter JenniferD
  • Start date Start date
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

Calculating Future Value 6
Calculation using a date 6
Years of Service Calculation 2
Scrabble Value calculation for Welsh words 0
Summation of months or years 6
Excel ADDING CPI AND RENT TO AN AMOUTN 1
Calculate eligibility/enrollment date 8
FV when compounding occurs every 30 months 2

Back
Top