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