Forum Discussion
Auto insert a Static date
I was wondering if there is a way to automatically insert the static date in a worksheet if value is entered in another cell. Example/reason. I have a UAT testing log, and when the customer selects...
To my knowledge there are two ways - use some VBA programming; or formula like this
=IF(A1<>"", IF(B1="",NOW(), B1), "")
but the latest requires that iterative calculations to be swithed on
what could have a negative side effect.