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