I am working with a client that has an old accounting system. I can get the
data over to excel, spend some time reformatting it and get a good sheet to
work with.

The system is a timecard based manufacturer, so employees will list the
date, pieces made, pieces scrapped. My problem is counting the days worked.
The spreadsheet will show several listings for the same day:

10/10/03 x x
10/10/03 x x
10/11/03
etc

I'd like to get a count for the actual number of days worked. If I just
count lines, I'm getting multiple lines for the same date because they work
on more than one type of piece each day. How can I get a count where it
will only count 10/10 once and then move on and give me an actual number of
days worked?

Thanks in advance.