Hi Barbara


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


Date Number Format =IF(A2-A10,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


--
Donkin
------------------------------------------------------------------------
Donkin's Profile: http://www.excelforum.com/member.php...o&userid=23715
View this thread: http://www.excelforum.com/showthread...hreadid=373871