Summing dates

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

See:

http://www.excelforum.com/showthread.php?t=558873

Just subtract

=B2-A2

--
HTH

Bob Phillips

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

"Snergle" <snergle2002@yahoo.com> wrote in message
news:e8j2jk$jo7$1@sunce.iskon.hr...
> 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
>
>