Return the value of a formula rather than the formula

K

Kreller

I want to make a formula that prints the date in the corrosponding cel
in col. B when i write something in a given cell in col. A. This
have done with the formula "=IF(A35<>"";TODAY();"")" set in cell B35.

The problem is that the "TODAY" function is dynamic and that the dat
is "updated" whenever I open the workbook. I want to make it static, s
I can see what date I have written somethin in the particular cell i
col. A.

Do you have a solution?
 
E

Earl Kiosterud

Kreller,

The IF solution won't work for a static date, as you have discovered. For a
static date, an event macro could put the date into the cell, in response to
a particular user action. You would have to determine when that should take
place, and write a suitable macro. We can do that for you with more
information. Or you may wish to simply do it manually. Ctrl - apostrophe,
followed by Enter puts the current date in a cell.
 
Top