I've got a formula that checks to see whether data has been added to a row, and if so it adds today's date to a column. It works well. The only problem is that every time the sheet is opened, it recalculates, so all the dates are set to today! Is there a way of adding in some logic to the formula to prevent this happening, or to set "recalculate=0" to a column!

Thanks for any help

James

Here's the formula:

=IF(ISBLANK(A6);"";TODAY())

...and here's a screenshot that might help:  http://take.ms/RvzsF