Using the =TODAY() option

[wormburner]

I have used the =TODAY() option to get a date to enter into a field if
another cell meets the requirements I set. However, I do not want the date to
change unless their is new data entered in the cell and it meets the
requirements.

Here is the formula I am currently using:

=IF($K8>0,TODAY(),(IF($L8>0,TODAY()," ")))

Basically, I want a date to be entered in a cell "J8" if K8, L8, or both are
greater than 0. I do not want the date to change unless K8 or L8 have new
data that are greater than 0. I am trying to date an activity.

Can anyone help?

 

[Eduardo]

Hi,
just a parenthesis problem

=IF($K8>0,TODAY(),IF($L8>0,TODAY()," "))

 

[wormburner]

Hello Eduardo,

You did not understand the question. I can get the date to be entered
automatically BUT it changes every day. I only want the date to change IF I
change the data in either of the 2 reference cells.

 

[Dave Peterson]

=today()
will always reevaluate when excel recalcs.

You may be able to use a macro to enter the time/date so that it doesn't change.

Take a look at JE McGimpsey's site:
http://www.mcgimpsey.com/excel/timestamp.html