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" wrote in message
...
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.