| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i calculate age in term of years, months, days
how do i calculate age in term of years, months, days
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i calculate age in term of years, months, days
Hi!
Try this: A1 = birthdate B1 = =NOW() Formula for the age: =DATEDIF(A1,B1,"y")&" years, "&DATEDIF(A1,B1,"ym")&" months, "&DATEDIF(A1,B1,"md")&" days" Will return something like: 29 years, 10 months, 11 days Biff "shan" wrote in message ... how do i calculate age in term of years, months, days |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i calculate age in term of years, months, days
Hi Biff
Thank u, it works SHAN "Biff" wrote: Hi! Try this: A1 = birthdate B1 = =NOW() Formula for the age: =DATEDIF(A1,B1,"y")&" years, "&DATEDIF(A1,B1,"ym")&" months, "&DATEDIF(A1,B1,"md")&" days" Will return something like: 29 years, 10 months, 11 days Biff "shan" wrote in message ... how do i calculate age in term of years, months, days |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i calculate age in term of years, months, days
You're welcome. Thanks for the feedback!
Biff "shan" wrote in message ... Hi Biff Thank u, it works SHAN "Biff" wrote: Hi! Try this: A1 = birthdate B1 = =NOW() Formula for the age: =DATEDIF(A1,B1,"y")&" years, "&DATEDIF(A1,B1,"ym")&" months, "&DATEDIF(A1,B1,"md")&" days" Will return something like: 29 years, 10 months, 11 days Biff "shan" wrote in message ... how do i calculate age in term of years, months, days |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I convert a number to number of years, months and days | Excel Worksheet Functions | |||
| Months or Years remaining, formatting | Excel Discussion (Misc queries) | |||
| Formula that will represent years & months worked | Excel Discussion (Misc queries) | |||
| Calculate months and years | Excel Discussion (Misc queries) | |||
| How do I display months and years between two dates | Excel Discussion (Misc queries) | |||
Linear Mode
