Date/Time Stamp

[Serjape]

I am trying to get a cell to add time date stamp if/when one of two other cells receive data. I am using this: =IF(OR(C100<>"",AND(D100<>"")),NOW(),"")
It is working but when you enter data on another line ALL Date/Time stamps update to that current time. I need it independat or individual to that cell. Any suggestions?

 

[HongRu]

Try.

Step1. Press Alt F T to go to Excel options. Select Formaul, check "Enable iterative calculation" and set "Maximum Iterations" as 1.

Step2. put the formula in cell B100.

=IF(OR(C100<>"",D100<>""),IF(B100="",NOW(),B100),"")

 

[Serjape]

Try.

Step1. Press Alt F T to go to Excel options. Select Formaul, check "Enable iterative calculation" and set "Maximum Iterations" as 1.
View attachment 82869

Step2. put the formula in cell B100.

=IF(OR(C100<>"",D100<>""),IF(B100="",NOW(),B100),"")

Does it matter if you put max iterations at 1 or 9999?

 

[Serjape]

Does it matter if you put max iterations at 1 or 9999?

So if i only had one cell like as in: =IF(C79<>"",IF(D79="",NOW(),D79),"")
How would that work?