Summing dates

S

Snergle

I have table like this
Date 1 Date2 Diff Date2-Date1
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.
For easyer calculations assume that month have 30 days.

Tahnx
 
B

Bob Phillips

Just subtract

=B2-A2

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

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 1
Datediff Help 3
No.f days between dates, no w/e and Fridays 2
how to return an address from a lookup into a table? 7
Date different between date and today date? 4
2 Criteria Summing 3
Sum.if date is in an interval... 6
Add value if date is in an interval... tricky?! 1

Top