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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed Neri - 03 Oct 2007 09:15 GMT

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.

Reply to this Message

Bob Phillips - 03 Oct 2007 10:00 GMT

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

Signature

---
HTH

Bob

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

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

Reply to this Message