Forum Discussion
Automatic Date entry
I hope someone can help and understand what i am asking. I have column B:B where data is inputted and would like column C:C to automatically input the date the data was inputted into column B:B. ...
Even though Mr. Hans Vogelaar was too quick for me :))),
I can recommend the NOW () function in addition to and as an alternative to Mr.Hans Vogelaar suggestion.
Example: =IF(A1="";"";IF(B1="";NOW();B1)).
Requirement what Mr. Hans Vogelaar described as a requirement (under Extras - Options - Calculation - Iteration - set the maximum number of iterations to 1).
Attached is an older example/file form Internet with VBA code, similar.