How do I count like dates in a column with format "January-05"?
 

I have a membership roster with a column of renewal dates in the format
"January-05".
I would like to count the number of like dates.

Example:
January-05
June-06
January 05

Result desired:
January-05 (2)
June-06 (1)

How do I count like dates in a column with format "January-05"?
 

Hi,

You can use Countif. For eg,

=COUNTIF($A$1:$A$100,"01/01/2005"). If you dont want to type the date
like that, you can refer to a cell where 'January-2005' is typed in. For
eg, if you have 'January-2005' in say A2, use

=COUNTIF($A$1:$A$100,A2)

Regards

Govind.


Kentski wrote:
I have a membership roster with a column of renewal dates in the format
"January-05".
I would like to count the number of like dates.

Example:
January-05
June-06
January 05

Result desired:
January-05 (2)
June-06 (1)

How do I count like dates in a column with format "January-05"?
 

One way ..

Assuming the column of renewal dates is col A,
data within A1:A100

In say, C1 down, you have listed:
January-05
June-06
etc

Put in D1:
=SUMPRODUCT(--(TEXT($A$1:$A$100,"mmmm-yy")=TEXT(C1,"mmmm-yy")))
Copy down

Col D will return the required counts
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kentski" wrote in message
...
I have a membership roster with a column of renewal dates in the format
"January-05".
I would like to count the number of like dates.

Example:
January-05
June-06
January 05

Result desired:
January-05 (2)
June-06 (1)

How do I count like dates in a column with format "January-05"?
 

I've assumed that the source col A may contain
actual dates as the real underlying data, eg:

1-jan-2005
15-jan-2005
2-jun-2006
13-jun-2006
etc

except that col A is formatted to display as: "mmmm-yy"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---