The =TODAY() function is linked to your computer's clock, so the formula you
described will always show today's date. What you would need to do, at the
end of each day, is copy the cell with the formula and paste
special...values. Then, you remove the link to today and the date will
always be the date you pasted values.

Hope this helps,
Jane

"Patrick Foley" wrote:

I have a cell that calculates the entry date of the row
eg =IF(A1630,$A$1,"No Data") In A1 I have =today()
This formula works fine but as I add a new row to the sheet the entry for
the day before changes to the current date. I want the entrys before current
entry to keep the date that was already there.