| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i convert a number of days to years, months & days?
I have calculated the number of days between 2 dates. Now I need to convert
this answer (number of days) to the number of years, months & days. xxx days = x years, xx months, xxx days |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i convert a number of days to years, months & days?
In Range A1:C2 (below)
Start Day End Day Difference 11/27/1944 8/22/2007 62 years, 8 months and 26 days Cell C2 = =DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months and " &DATEDIF(A2,B2,"md") & " days" Watch for wrapping of this single formula... "SafetyLen" wrote: I have calculated the number of days between 2 dates. Now I need to convert this answer (number of days) to the number of years, months & days. xxx days = x years, xx months, xxx days |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a number into Years, Months, Days format? | Excel Worksheet Functions | |||
| how to convert 12/10/1970 to years/months/days | New Users to Excel | |||
| Number of years/months/days between 2 dates | Excel Worksheet Functions | |||
| convert Days to Years, Months, Days | Excel Discussion (Misc queries) | |||
| how do I convert a number to number of years, months and days | Excel Worksheet Functions | |||
Linear Mode
