Formula Help: adding date when row has an entry

Formula Help: adding date when row has an entry

Hi all,
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