Counting days worked

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.

Looks like a count of distinct days is what you require...

=SUMPRODUCT((DateRange<>"")/COUNTIF(DateRange,DateRange))

anonymous person wrote:
> 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.
>
>

Make that:

=SUMPRODUCT((DateRange<>"")/COUNTIF(DateRange,DateRange&""))

Aladin Akyurek wrote:
> Looks like a count of distinct days is what you require...
>
> =SUMPRODUCT((DateRange<>"")/COUNTIF(DateRange,DateRange))
>
> anonymous person wrote:
>
>> 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.
>>

thank you, I will try that out this afternoon.
"Aladin Akyurek" <akyurek@xs4all.nl> wrote in message
news:41F2A684.9060801@xs4all.nl...
> Make that:
>
> =SUMPRODUCT((DateRange<>"")/COUNTIF(DateRange,DateRange&""))
>
> Aladin Akyurek wrote:
>> Looks like a count of distinct days is what you require...
>>
>> =SUMPRODUCT((DateRange<>"")/COUNTIF(DateRange,DateRange))
>>
>> anonymous person wrote:
>>
>>> 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.
>>>