How do I compute for a person's age in Excel to show also months?.

G

Guest

I am trying to compute in Excel 2007, the length of service of employees.
While I have been able to computer the years, I would like to see the number
of months and days rather than a fraction of the year.
 
B

Bob Phillips

=DATEDIF(A1,TODAY(),"Y")&" years, "&DATEDIF(A1,TODAY(),"YM")&" months"

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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

Age computation 1
Average Age 4
Formula to Calculate Dates 1
Excel - Calculate age from DOB in years, months days 7
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
How do I calculate a person's age on a specific date? (huge roster 2
Calculating a person's age 2
Excel 1 vs 10 in Excel Formula 0

Top