| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CALCULATE THE ACTUAL AGE IN TERMS OF YEARS, MONTHS AND DAYS
so it shows a result of "15 years 4 months and 6 days" for example.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CALCULATE THE ACTUAL AGE IN TERMS OF YEARS, MONTHS AND DAYS
Hi
With earliest date in A1 and latest date in A2 =DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days" -- Regards Roger Govier "jr" wrote in message ... so it shows a result of "15 years 4 months and 6 days" for example. |
|
#3
|
|||
|
|||
|
HI, I use this formula and was very helpful. But, in some cases, the result appears as: 9 years 1 month 140 days. How I can fix the output format for days that appear until 31 days?
ThankYou! :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i convert a number of days to years, months & days? | Excel Discussion (Misc queries) | |||
| HOW DO I CALCULATE THE YEARS MONTHS AND DAYS BETWEEN SEVERAL DATE | Excel Discussion (Misc queries) | |||
| how do i calculate age in term of years, months, days | Excel Worksheet Functions | |||
| how do i calculate age in term of years, months, days | Excel Worksheet Functions | |||
| Function to calculate the number of years, months and days between | Excel Worksheet Functions | |||
Linear Mode
