| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date String
I have 2 dates and I want to calculate the difference expressed as the
following string: (eg) 9 Years 3 months and 13 days Can anyone help? Many Thanks John - Sydney Aust. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date String
Hi John
Assuming earlier date in A1 and later date in A2 then you can use the following formula: =DATEDIF(A1,A2,"y") & " years " & DATEDIF(A1,A2,"ym") & " months and " & DATEDIF(A1,A2,"md") & " days" Hope this helps! Richard On 28 Feb, 09:35, "Jester" wrote: I have 2 dates and I want to calculate the difference expressed as the following string: (eg) 9 Years 3 months and 13 days Can anyone help? Many Thanks John - Sydney Aust. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert string to date | Excel Worksheet Functions | |||
| How to parse a string with a date? | Excel Worksheet Functions | |||
| extract date from string | Excel Worksheet Functions | |||
| convert string to date | Excel Worksheet Functions | |||
| Convert Date to STring | Excel Discussion (Misc queries) | |||
Linear Mode
