View Single Post
  #1   Report Post  
John
 
Posts: n/a
Default Dates to numbers

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