Counting Dates
 

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

Counting Dates
 

Try this formula in B2

=COUNTIF(A:A,A2)

If this post helps click Yes
---------------
Jacob Skaria


"klafert" wrote:

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

Counting Dates
 

This works perfect - Thanks

"Jacob Skaria" wrote:

Try this formula in B2

=COUNTIF(A:A,A2)

If this post helps click Yes
---------------
Jacob Skaria


"klafert" wrote:

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