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?