Thread
:
How do I compute for a person's age in Excel to show also months?.
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Bob Phillips
external usenet poster
Posts: 10,593
How do I compute for a person's age in Excel to show also months?.
=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)
"Ed Neri" <Ed
wrote in message
...
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 With Quote
Bob Phillips
View Public Profile
Find all posts by Bob Phillips