I did not say your formula was wrong. I was giving the OP data as it was
obvious that the OP's request is not quite clear. You interpreted the OP
wanted number of unique dates. I interpreted that the OP wanted to know how
many times the date changed. I was giving the OP as much info as possible,
as, like I said, the OP's original request is ambiguous.
--
** John C **

"Mike H" wrote:

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