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

[Guest]

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)

 

[Govind]

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.

 

[Max]

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]

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"

---