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)
 
Top