If you are saying that you want to type a new date into a cell that has an
existing date, and then count that as a new entry, you are entering either
ground for circular calculations/iterations, or VBA territory. Either way it
is going to get tricky.

There might be a different/better way without entering into that kind of
stuff, perhaps if you detailed a little more about what you are trying to
capture.
--
** John C **

"NM" wrote:

Thanks much for your responses.
Understanding that my question was a little unclear. I want to provide some
input to clarify it.
I have 120 rows of different Projects with 16 columns of dates. In a column
I want to find out how many times date changes in a single cell.Say, A2 was
12/10/08 and it changed to 12/20, so it should be counted as one.
Similarly if A3 changes from 12/10 to 12/1, it should be counted and the
total change in the column would be 2.
Let me know if I'm still unclear.

Thanks!




"John C" wrote:

Question is a little unclear. I am interpreting your question rephrased as:
"I have a column with dates, and I want to know how many times the date
changes from row to row as I go down the column."
Assume your dates are in cells A2:A100, this formula, I believe, will give
you what you want:
=SUMPRODUCT(--($A$2:$A$99<$A$3:$A$100))
So say you had dates ranged A2:A7 as so:
10/17/08 | 10/17/08 | 10/18/08 | 10/19/08 | 10/19/08 | 10/20/08
Your result should be 3, as it changes from 10/17/08 to 10/18/08, then the
next cell to 10/19/08, and one more time to 10/20/08.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"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