Do you realize that the TODAY() function is volatile and will change when
you open the workbook tomorrow?

I would go with Mike's event code to add a static date in column A whenever
a cell in Column C is changed.


Gord Dibben MS Excel MVP

On Fri, 17 Oct 2008 08:53:01 -0700, digitalmuse
wrote:

It does work in a cell - im trying now to get it to work in all the cells in
that column(range)

thanks for the assist !

"Pete_UK" wrote:

Try it this way, then:

=IF(COUNTA(C:C)0,TODAY(),"")

Hope this helps.

Pete

On Oct 17, 3:39 pm, digitalmuse
wrote:
thanks for the responses and i guess i should have been clearer, the formula
cant depend on input to cell c4 only it needs to apply to any entry made in
column C