Calculate number of days in a column of dates

Hi again,

I still have a problem!!! In this list, with your formula, it returns 16
days. But the right answer is 14. Why? How can I have the right answer?
02-Dez
02-Dez
02-Dez
02-Dez
02-Dez
02-Dez
02-Dez
02-Dez
03-Dez
07-Dez
07-Dez
09-Dez
10-Dez
10-Dez
13-Dez
13-Dez
13-Dez
14-Dez
14-Dez
15-Dez
15-Dez
15-Dez
15-Dez
16-Dez
16-Dez
17-Dez
17-Dez
17-Dez
20-Dez
20-Dez
21-Dez
21-Dez
21-Dez
21-Dez
21-Dez
22-Dez
22-Dez
23-Dez
23-Dez

What was the original question?

"Barbara" wrote:

> Hi again,
>
> I still have a problem!!! In this list, with your formula, it returns 16
> days. But the right answer is 14. Why? How can I have the right answer?
> 02-Dez
> 02-Dez
> 02-Dez
> 02-Dez
> 02-Dez
> 02-Dez
> 02-Dez
> 02-Dez
> 03-Dez
> 07-Dez
> 07-Dez
> 09-Dez
> 10-Dez
> 10-Dez
> 13-Dez
> 13-Dez
> 13-Dez
> 14-Dez
> 14-Dez
> 15-Dez
> 15-Dez
> 15-Dez
> 15-Dez
> 16-Dez
> 16-Dez
> 17-Dez
> 17-Dez
> 17-Dez
> 20-Dez
> 20-Dez
> 21-Dez
> 21-Dez
> 21-Dez
> 21-Dez
> 21-Dez
> 22-Dez
> 22-Dez
> 23-Dez
> 23-Dez

Hi Barbara


Convert the date to the Excel number format by using format - number


Date Number Format =IF(A2-A1>0,1,0)


A B C
Blank Line......................................
2-Dec 38688 1
2-Dec 38688 0
2-Dec 38688 0
2-Dec 38688 0
2-Dec 38688 0
2-Dec 38688 0
2-Dec 38688 0
2-Dec 38688 0
3-Dec 38689 1
7-Dec 38693 1
7-Dec 38693 0
9-Dec 38695 1
10-Dec 38696 1
10-Dec 38696 0
13-Dec 38699 1
13-Dec 38699 0
13-Dec 38699 0
14-Dec 38700 1
14-Dec 38700 0
15-Dec 38701 1
15-Dec 38701 0
15-Dec 38701 0
15-Dec 38701 0
16-Dec 38702 1
16-Dec 38702 0
17-Dec 38703 1
17-Dec 38703 0
17-Dec 38703 0
20-Dec 38706 1
20-Dec 38706 0
21-Dec 38707 1
21-Dec 38707 0
21-Dec 38707 0
21-Dec 38707 0
21-Dec 38707 0
22-Dec 38708 1
22-Dec 38708 0
23-Dec 38709 1
23-Dec 38709 0

=SUM(c1:c 40) Gives 14.00

Hope it helps

Donkin