Counting Dates

[klafert]

I have a spreadsheet that has dates in each column. I need to have the
number of times a date occurs and have that number put in another column.

Example

Date NO. of dates
6/1/09 3
6/1/09 3
6.1.09 3
6/2/09 2
6/2/09 2

 

[klafert]

This works perfect - Thanks

Try this formula in B2

=COUNTIF(A:A,A2)

If this post helps click Yes