Hi,

My formula does exactly what I wanted it to do. My understanding of the OP
requirement is different to yours, I'm looking for the number of unique dates.

Mike

"John C" wrote:

Using a small Data Set of 5
10/17/08 | 10/17/08 | 10/17/08 | 10/17/08 | 10/17/08
Your formula results = 1, my formula results = 0

10/17/08 | 10/17/08 | 10/18/08 | 10/18/08 | 10/18/08
Your formula results = 2, my formula results = 1

10/17/08 | 10/17/08 | 10/18/08 | 10/18/08 | 10/17/08
Your formula results = 2, my formula results = 2

10/17/08 | 10/18/08 | 10/19/08 | 10/18/08 | 10/17/08
Your formula results = 3, my formula results = 4
--
** John C **



"Mike H" wrote:

Try,

=SUMPRODUCT((A1:A100<"")*(ISNUMBER(A1:A100)/(COUNTIF(A1:A100,A1:A100&""))))

Mike

"NM" wrote:

Hi,

I want to record/count the number of times a date changes in any cell in a
column?

I will appreciate all your help.Please let me know.

Thanks!
NM