|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 28th, 2007, 09:35 AM
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
February 28th, 2007, 10:00 AM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
