Summing dates

  • Thread starter Thread starter Snergle
  • Start date Start date
S

Snergle

Have table like this

Date1 Date2 Diff Date1+Date2
19.12.05 10.01.06 0Y 0M 22D

14.01.05 26.02.05 0Y 1M 13D



Which formula to use to sum dates in column 3.
Assuming (for easyer calculation) that months have 30 days

Thx
 
It looks like you want difference between dates (not sum).

If that is correct, then try

=DATEDIF(A2,B2,"y") & "Y " & DATEDIF(A2,B2,"ym") & "M " &
DATEDIF(A2,B2,"md") & "D"

Note: This will use exact dates in each month (not just 30 days/month)
 
Back
Top