Summing dates

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
 
V

Vito

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing dates 2
top 3 dates in calculations : Function 3
Top 3 dates in calculation Function / Query? 3
Datedif gives wrong result 1
Event for Field Change 2
calculate "working minutes" between 2 dates 3
Summing values based on calendar dates 5
IF Statement with Dates & Calculations 5

Top