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($K80,TODAY(),(IF($L80,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?

Hi,
just a parenthesis problem

=IF($K80,TODAY(),IF($L80,TODAY()," "))

"wormburner" wrote:

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($K80,TODAY(),(IF($L80,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?

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.

"Eduardo" wrote:

Hi,
just a parenthesis problem

=IF($K80,TODAY(),IF($L80,TODAY()," "))

"wormburner" wrote:

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($K80,TODAY(),(IF($L80,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?

=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

wormburner wrote:

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($K80,TODAY(),(IF($L80,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?

--

Dave Peterson