Today or Now functio

[Guest]

I have a cell that calculates the entry date of the row
eg =IF(A163>0,$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.

 

[Guest]

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

 

[Dave O]

Your formula will work all day because Excel evaluates TODAY as the
same date all day. When you open the file the next day Excel will
replace the date in A1 with the current date, and change the cells that
depend on cell A1.

One workaround for this is to copy the cells in question, and Paste
Special them back over those same cells as values. This replaces the
formula with the value of the formula.

 

[Gord Dibben]

Patrick

Instead of having = TODAY() in A1, just enter the date using CTRL +
;(semi-colon).

It will be the current date when entered and remain static.


Gord Dibben Excel MVP