Dates to numbers

[John]

Hi,
I am working on a spreadsheet and need to convert a resulting date (when
I subtract 2 dates say, 02/01/1996 from 22/04/1998) to a number showing
"Days:Months:Years".In the above example I should get 22:03:02. What formula
should I apply to the resulting column (from the subtraction of the dates)to
give me that result.Thanks in advance,
John

 

[Ron de Bruin]

Hi John

A formula from Norman Harker to do this with the dates in B5 and C5

=DATEDIF(B5,C5,"y") & " y " & DATEDIF(B5,C5,"ym") & " m " & DATEDIF(B5,C5,"md") & " d"

You can adapt it to your format

 

[John]

Thanks Ron