W
wx4usa
Is there a way to count the specific instances/occurances of dates?
I may run as many as 3 delivery trucks on a specific day. On some days
no trucks run. I want to count how many days in a month I deliver.
Without counting the multiples.
I have a list of dates in column A .
Column a represents data about each truck run.
The other columns show other delivery related data.
01/02/06
01/02/06
01/03/06
01/05/06
02/05/06
02/15/06
etc
Is there a way to count the number of days represented/delivered in
January (or any specified month) 2006 WITHOUT counting January 2nd
2X's?
Just the number of days out of 31 that have shown activity?
I may run as many as 3 delivery trucks on a specific day. On some days
no trucks run. I want to count how many days in a month I deliver.
Without counting the multiples.
I have a list of dates in column A .
Column a represents data about each truck run.
The other columns show other delivery related data.
01/02/06
01/02/06
01/03/06
01/05/06
02/05/06
02/15/06
etc
Is there a way to count the number of days represented/delivered in
January (or any specified month) 2006 WITHOUT counting January 2nd
2X's?
Just the number of days out of 31 that have shown activity?